Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
99
votes
11 answers

MongoDB Full and Partial Text Search

Env: MongoDB (3.2.0) with Mongoose Collection: users Text Index creation: BasicDBObject keys = new BasicDBObject(); keys.put("name","text"); BasicDBObject options = new BasicDBObject(); options.put("name", "userTextSearch"); …
Leonel
  • 2,796
  • 5
  • 25
  • 36
38
votes
4 answers

Multilingual elasticsearch indexing best practice/experiences

Wondering what are the best practice or experiences used for multilingual indexing and search in elasticsearch. I read through a number of resources, and as best as I can distill it the available options for indexing are: separate index per…
ilijaluve
  • 1,050
  • 2
  • 10
  • 24
34
votes
2 answers

Postgresql prefix wildcard for full text

I am trying to run a fulltext query using Postgresql that can cater for partial matches using wildcards. It seems easy enough to have a postfix wildcard after the search term, however I cannot figure out how to specify a prefix wildcard. For…
Paul Carey
  • 516
  • 1
  • 4
  • 15
34
votes
5 answers

Lucene.Net Best Practices

What are the best practices in using Lucene.Net? or where can I find a good lucene.net usage sample?
Elias Haileselassie
  • 1,385
  • 1
  • 18
  • 26
31
votes
4 answers

Use of indexes for multi-word queries in full-text search (e.g. web search)

I understand that a fundamental aspect of full-text search is the use of inverted indexes. So, with an inverted index a one-word query becomes trivial to answer. Assuming the index is structured like this: some-word -> [doc385, doc211, doc39977,…
Luís Marques
  • 991
  • 1
  • 10
  • 20
25
votes
6 answers

strpos() with multiple needles?

I am looking for a function like strpos() with two significant differences: To be able to accept multiple needles. I mean thousands of needles at ones. To search for all occurrences of the needles in the haystack and to return an array of starting…
Nikola Obreshkov
  • 1,698
  • 4
  • 21
  • 32
25
votes
2 answers

Code first custom SQL migration timeout exception

I am trying to create FULL TEXT index using Entity Framework Migration by executing custom Sql. My migration class looks like this: public partial class DocumentContentFullTextIndex : DbMigration { public override void Up() { …
Nick
  • 798
  • 1
  • 7
  • 14
25
votes
1 answer

FullText search with CONTAINS on multiple columns and predicate - AND

I have a search table with, say, 4 columns of text data to search. I do something like this: SELECT * FROM dbo.SearchTable WHERE CONTAINS((co1, col2, col3, col4), 'term1 AND term2') It looks like Contains only returns true if term1 and term2 are in…
user3083558
22
votes
2 answers

Warning: A long semaphore wait

For the past 4 days I have had massive problems with my nightly updates, except for 1 night were it all went fine in between these 4 days. During these updates i update a couple of fulltext indexes. I do it in this manner. Drop the fulltext…
Mad Dog Tannen
  • 7,129
  • 5
  • 31
  • 55
21
votes
3 answers

Faster search in Lucene - Is there a way to keep the whole index in RAM?

Is there a way of keeping the index in RAM instead of keeping it on the hard disk? We want to make searching faster.
elif
  • 5,427
  • 3
  • 28
  • 28
21
votes
6 answers

How to identify if a Lucene.Net Index exists in a folder?

I am using Lucene.Net for indexing and searching documents, and I am using the following code to create or open an index if one exists: IndexWriter writer = new IndexWriter(@"C:\index", new StandardAnalyzer(), !IndexExists); ... private bool…
Elias Haileselassie
  • 1,385
  • 1
  • 18
  • 26
18
votes
3 answers

How to crawl a website that has SAML authentication using ManifoldCF or nutch?

I am trying to crawl a website, more specifically a Google Site using ManifoldCF that has SAML authentication and index the crawled data into Apache Solr. But as I crawl the URL, it gives me 302 redirection to login page and then says…
Saurabh Chaturvedi
  • 2,028
  • 2
  • 18
  • 39
18
votes
4 answers

Will indexing improve varchar(max) query performance, and how to create index

Firstly, I should point out I don't have much knowledge on SQL Server indexes. My situation is that I have an SQL Server 2008 database table that has a varchar(max) column usually filled with a lot of text. My ASP.NET web application has a search…
johna
  • 10,540
  • 14
  • 47
  • 72
15
votes
1 answer

How does MySQL fulltext search work?

I have a pretty good idea how to implement fulltext search with MySQL. I know how to add indexes and make a query and sort my results. But I have been trying to get some more in-dept information on how it works, so to say what happens behind the…
lejahmie
  • 17,938
  • 16
  • 54
  • 77
14
votes
3 answers

How to define if rebuilding of the full text index has finished?

Got a requirement to rebuild mssql full-text index. Problem is - I need to know exactly when job is done. Therefore - just calling: ALTER FULLTEXT CATALOG fooCatalog REBUILD WITH ACCENT_SENSITIVITY = OFF doesn't work or I'm doing something…
Arnis Lapsa
  • 45,880
  • 29
  • 115
  • 195
1
2 3
…
37 38