indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
2
votes
1 answer
mysql match/against
I'm using this search
-> match (c1, c2) against (">dg*" in boolean mode);
and I get this list
1 dgas
2 dgica
3 dgicb
4 dgii
5 dgit
6 dgly
7 dgc
8 dgse
which seems reasonable.
The problem is that I DON'T get "dgl", which I know…
adamD
- 125
- 2
2
votes
1 answer
Best practices for index/fulltext when using WHERE/LIKE
Should I set the columns to in my table as index or fulltext? They will be searched for both using WHERE and WHERE .. LIKE.
Which is best?
benji
- 23
- 3
2
votes
0 answers
Indexing and Crawling using nutch with solr
Am newbie to nutch and solr, I trying to index and crawl a single website using Nutch with solr but am getting this error., I don't know what is the exact error. can anyone help me with this ? Thanks in advance.
Segment dir is complete:…
Vinod kumar
- 87
- 1
- 12
2
votes
1 answer
Indexing markdown documents for full text search in Apache SOLR
I am using Apache SOLR to index markdown documents.
As you know, Markdown is basically plaintext with special tags for formatting like bold and italic.
The problem is: if the markdown has bold or italic formatting, the fulltext search is not…
Chetan Yewale
- 192
- 4
- 16
2
votes
2 answers
MongoDB: language override unsupported: arabic
I am trying to make a text index on a book document containing data in multiple languages (Essentially: English, French and Arabic).
In the documentation it is said that Arabic is supported, but when I try to create a document with these…
Burawi
- 451
- 4
- 16
2
votes
0 answers
How to use both fulltext index and normal index in MySQL
l have a very large table in mysql database, and it is the first time to me to query a table so large like this. PS: about 2 million row, 40G size.
this is a table for news, so l have a fulltext index on field content, but l also need to order the…
afraid.jpg
- 965
- 2
- 14
- 31
2
votes
1 answer
Lucene: output elaborated data by adding IR information to it
I need to process a database in order to add meta-information such as td-idf weights to the documents terms.
Successively I need to create document pairs with similarity measures such as td-idf cosine similarity, etc...
I'm planning to use Apache…
aneuryzm
- 63,052
- 100
- 273
- 488
2
votes
1 answer
MYSQL - MATCH AGAINST score value = 0 but is >0 in WHERE clause
I have 2 similar DB, on 2 servers.
If i try to execute this request one each one :
SELECT u.lastname, MATCH (u.lastname) AGAINST ('Rod*' IN BOOLEAN MODE)
FROM user u
WHERE MATCH (u.lastname) AGAINST ('Rod*' IN BOOLEAN MODE) > 0 ;
On the first…
Toon
- 53
- 3
2
votes
2 answers
Indexing text - MySQL vs. MS SQL
image you have application like this : 1 DB table, few int fields, few small varchar fields, and about 10 TEXT fields (contents variable - some data about 50 chars long, most about 100-200, some about 1000, very few more than 1000). Row count is in…
rouen
- 5,003
- 2
- 25
- 48
2
votes
2 answers
Django full text search using indexes with PostgreSQL
After solving the problem I asked about in this question, I am trying to optimize performance of the FTS using indexes.
I issued on my db the command:
CREATE INDEX my_table_idx ON my_table USING gin(to_tsvector('italian', very_important_field),…
Biagio Distefano
- 130
- 1
- 13
2
votes
2 answers
unknown top level operator: $orderby
We've a node.js + mongoose app running on Ubuntu linux servers spun on DigitalOcean VPS.
One of our mongoose queries have a text index with the following operators:
less than / equal to
limit
order by
and looks like…
Zameer Ansari
- 28,977
- 24
- 140
- 219
2
votes
1 answer
MySQL - FULL TEXT INDEX ON FREQUENTLY UPDATED COLUMNS
I have the following table design with a full text index and the following query:
CREATE TABLE artists (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title varchar(255) NOT NULL,
description text NOT NULL,
category_id INT…
adam78
- 9,668
- 24
- 96
- 207
2
votes
0 answers
Full Text Search using Indexing
Can i create a full-text Search index on Non unique column having duplicate values?
We have sql query in which we need to get distinct records based on LIKE operator and we have approx 20 million data in a table and our requirement is get final…
Shilpa Garg
- 19
- 2
2
votes
1 answer
SQL Server 2016 Full-Text Index suddenly stops working
We are successfully using Full-Text Indexing, but multiple times a week it suddenly stops working.
Going to the affected table and disabling the Full-Text Index, then
enabling it again brings it back to life. But that's no good in a production…
Bob
- 65
- 7
2
votes
2 answers
FULLTEXT index on one column vs multiple columns in following scenario?
I have this table structure and I am using MYSQL
post` (
`post_id_pk` INT,
`title` VARCHAR(100),
`description` TEXT,
`search_content` TEXT
)
I have a search functionality. IF an user type a text into textbox and if that word contains in…
Prageeth Liyanage
- 1,612
- 2
- 19
- 41