Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
2 answers

How to search for a word or phrase in SQL Server 2014 Tables?

I have multiple tables (say TableA, TableB, TableC) which have columns to store values in 6 languages. There are thousands of rows in each of these tables in SQL Server 2014. What is the best way to search for a word or phrase or search string in…
Bhanu
  • 831
  • 3
  • 13
  • 28
0
votes
2 answers

MySQL: Why I get no results for a specific query on fulltext index?

I have some trouble with a MySQL table and a fulltext index. My table structure looks similar to this: CREATE TABLE example_index ( id int(11) NOT NULL auto_increment, title tinytext, content text, FULLTEXT INDEX title (title), …
Fox
  • 623
  • 8
  • 35
0
votes
1 answer

error when synchronizing CONTEXT index

I have a full text database application with a simple procedure which inserts values into a table: create or replace PROCEDURE put_file ( p_file_name IN my_doc.file_name%TYPE, p_upload_date IN my_doc.upload_date%TYPE, …
mikcutu
  • 1,013
  • 2
  • 17
  • 34
0
votes
1 answer

speed full text search index using codeigniter is not working as much as speed

am having the issues in full-text search using CodeIgniter. here, am having one table with dynamic rows and columns, when I searching input field to one row using full-text index is coming by very slowly. here have already set the following values…
user3839366
  • 9
  • 2
  • 11
0
votes
2 answers

Why Lucene index is so large?

I am storing documents in a Lucene instance the following way: Document doc = new Document(); doc.add(new StringField("title", processor.title, Field.Store.YES)); doc.add(new StringField("annotation", processor.annotation,…
Denis Kulagin
  • 8,472
  • 17
  • 60
  • 129
0
votes
2 answers

Issue with Solr Indexing, Solr Indexing Chain is not complete

In my solr, i get this result after running analysis for Indexing. I have a number of documents containing the word Machine Learning but seems like something broke and indexing chain didn't complete. Can i find a work-around for this? Field type is…
Kabhi
  • 135
  • 1
  • 12
0
votes
1 answer

MySQL match against 'ch' in utf8_czech_ci

We are successfully using MATCH AGAINST in queries to search in our database, which is mostly in Czech, so we use utf8_czech_ci as default collation. We have set minimum length of query to 1 and we have disabled all the stop words. However, consider…
Vojtěch
  • 11,312
  • 31
  • 103
  • 173
0
votes
1 answer

SQL Server 2000 Full Text Index running on Windows Server 2008

I have SQL Server 2000 SP4 running on Windows Server 2008, and I'm trying create a full text catalog that includes full text indexes on a few tables. The catalog has an Item Count of 53676, but a unique key count of only 8. On another database (a…
Yisroel
  • 8,164
  • 4
  • 26
  • 26
0
votes
0 answers

MySQL: Is it possible to obtain words of a fulltext index?

I like to sort a BOOLEAN wildcard search by relevance. As BOOLEAN has only a binary score we need to use the NATURAL mode to obtain a weight score. But NATURAL does not support operators so it will not return any results (score = 0): mysql>SELECT …
mgutt
  • 5,867
  • 2
  • 50
  • 77
0
votes
1 answer

Find the word 'x++' in Fulltextsearch SQLServer

I'm trying to indexing the word 'x++' in my fully indexed field, but I don't know how. I think the problem is that the '+' char is not included in indexing list chars. Executing the query: SELECT * FROM sys.dm_fts_index_keywords(DB_ID('my_db'),…
Anna Ghidinelli
  • 1
0
votes
2 answers

MySQL FULLTEXT Search Running Extremely Slowly

Working on a small data set of less than 50 rows, the following query below works absolutely fine. When scaling this up and running the same query on a data set of around 5000 rows, this query takes around 3-6 seconds to run which is way too slow on…
Michael Cropper
  • 872
  • 1
  • 10
  • 28
0
votes
4 answers

How to index a web site

I'm asking on behalf of somebody, so I don't have too many details. What options are available for indexing site content in an ASP.NET web site? I suspect SQL Server's Full Text index may be used if the page content is stored in the database. How…
ProfK
  • 49,207
  • 121
  • 399
  • 775
0
votes
1 answer

Fulltext index search has large number of page reads

I have a full-text index on a column in a table that contains data like this: searchColumn 90210 Brooks Diana Miami FL diana.brooks@email.com 5612233395 The column is an aggregate of Zip, last name, first name, city, state, e-mail and phone…
Radu Gheorghiu
  • 20,049
  • 16
  • 72
  • 107
0
votes
1 answer

Find whether an object with multifields contains a string

{ "_id" : ObjectId("5811b03d231d884982672ddd"), "person-name" : "Bell, Lee Phillip", "info" : { "trivia" : [ "Mother-in-law of 'Colleen Bell (II)' (qv) and 'Maria Arena Bell' (qv).", "Mother of actress…
zhelyu
  • 41
  • 1
  • 3
0
votes
1 answer

What is the fastest way to search through MySQL database to match strings?

I need to search through around a million records to find out whether an inputted company name is on the database or not, and if it isn't then get suggestions for changing the input depending on what does exist on the database. Presumably FULLTEXT…
A. Appleby
  • 469
  • 1
  • 10
  • 23
1 2 3
…
37 38