Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
2
votes
1 answer

MySQL fulltext search and sort by relevance + TIME

I'm trying to show "related articles" block on my website. For this purpose I use the following query: SELECT *, MATCH(title, content) AGAINST('search string') AS score FROM news_items WHERE MATCH(title, content) AGAINST('search string') ORDER BY…
Gregory
  • 51
  • 1
  • 9
2
votes
1 answer

MongoDB full text search - matching words and exact phrases

I'm currently having some issues with the full text search functionality in MongoDB. Specifically when trying to match exact phrases. I'm testing out the functionality in the mongo shell, but ultimately I'll be using Spring Data MongoDB with…
robarthur1
  • 457
  • 2
  • 9
  • 19
2
votes
1 answer

SQL Server Fulltext search yields no results

I have SQL Server 2005 Express Edition with Advanced Services. I enabled FullText and created a catalog as follows: create FullText catalog MyDatabase_FT in path 'mypath' as default I then created a FullText index as follows: create FullText index…
Elan
  • 6,084
  • 12
  • 64
  • 84
2
votes
1 answer

How to change full text index minimum word length with MySQL?

I'm using windows operating system and xampp control panel. I want to change full text index minimum word length. Most of post explain it can be changed through mysql my.ini file. But my mysql my.ini file doesn't show any thing as "ft_min_word_len".…
Maduri
  • 249
  • 1
  • 5
  • 19
2
votes
2 answers

Couple o' quick questions on Apache Lucene

-- I don't want to start any religious wars, but a quick google search indicates that Apache Lucene is the preferred open source tool for indexing and searching. Are there others? -- What file format does Lucene use to store its index…
Doug
  • 1,925
  • 3
  • 13
  • 9
2
votes
5 answers

Save a binary file in SQL Server as BLOB and text (or get the text from Full-Text index)

Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions. Does anyone know of a simple way to either…
Glennular
  • 17,827
  • 9
  • 58
  • 77
2
votes
2 answers

SQL Server CONTAINS with digits gives no results

I have a database table which is full-text indexed and i use the CONTAINS-function to perform a search-query on it. When I do: SELECT * FROM Plants WHERE CONTAINS(Plants.Description, '"Plant*" AND "one*"'); I get back all correct results matching a…
dale
  • 760
  • 5
  • 11
2
votes
1 answer

Find records with an empty full text index

I am storing document binaries (mostly PDF files) in a SQL Server database and am using the Acrobat IFilter and full-text indexing to make the contents of the files searchable. However, some of these PDFs were scanned with really cheap software that…
Paul Abbott
  • 7,065
  • 3
  • 27
  • 45
2
votes
1 answer

Manual Fulltext index population time in SQL Server 2012

I would like to know if there is a way to see how much time did it take SQL Server 2012 to index all the data in a table? In my example I create the table, create the index and set the population to be manual. Then I execute ALTER FULLTEXT INDEX ON…
Rosen Dimov
  • 1,055
  • 12
  • 32
2
votes
1 answer

difference of fulltext index on many columns vs one accumulated column

I just stumbled upon the maximum column restriction of a fulltext index on adding it to many columns: ALTER TABLE some_table ADD FULLTEXT (col1, col2, col3, col4, col5, col6, ...); This can result into the following error: 1070 Too many key parts…
Markus
  • 5,667
  • 4
  • 48
  • 64
2
votes
1 answer

Lucene: multiple documents for a single "resource"

My model here consists on online courses. Every course has got an id number, a title and can have a different number of content files (large html files). I tried to represent them in Lucene using the following scheme (every line is a…
grieih
  • 143
  • 2
2
votes
1 answer

#1191 - Can't find FULLTEXT index matching the column list

Iam trying to execute this query in my xampp, but it is not turning up. SELECT pid,description,alttext FROM wp_ngg_pictures WHERE MATCH (description, filename, alttext) AGAINST ('*image2*' IN BOOLEAN MODE) AND exclude != 1 it has returned this…
user3219680
  • 49
  • 1
  • 1
  • 4
2
votes
2 answers

Fulltext index and search speed

Question concerning a database / speed issue on a PHP/MySql website. A query with fulltext search seems to be very slow. I'm not an SQL expert, just simple basic php/html programming for basic websites and somebasic MySQL knowledge. Customer has…
user3272710
  • 21
  • 4
2
votes
1 answer

Choosing database for full-text-indexing (SQL/NoSql)

I'm searching for a good solution to build a large databased-full-text-index. Currently i'm using a Sybase iAnywhere Database for my full-text-index, but with a growing database it seems to be slow. Now i'm not sure, if this is a problem with…
BendEg
  • 20,098
  • 17
  • 57
  • 131
2
votes
1 answer

Index defaults to Allow Nulls 'YES' when I convert columns to NVarchar on an indexed view

Some background: I'm on sql server 2005 (I know :( ...) Briefly: I am concatenating three varchar columns and converting them to nvarchar as a column in a schema-bound, indexed view. All three columns are pkeys and not null. But when the…
theMothaShip
  • 1,191
  • 1
  • 12
  • 24
1 2 3
…
37 38