indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
0
votes
1 answer
Full text search records not showing up
I have a column in my table to which I have added a Full Text Index. When I write a query to do contains on that particular column, the query gives the output of those records which matches with contain and which were added to the table before 3-4…
Hitesh
- 3,449
- 8
- 39
- 57
0
votes
0 answers
SQL Table and Full-Text Index Partitioning
I have an application that uses Microsoft SQL Server 2012 to store information and text extracted from documents amongst other things. A single table (let's call it "Docs") stores most of this information and has a "Status" field that determines…
CruzyBruce
- 1
- 1
0
votes
2 answers
sql server 2005 full text index query to help find noise words in content
Is there a way to query a full text index to help determine additional noise words? I would like to add some custom noise words and wondered if theres a way to analyse the index to help determine suggestions.
Peter Willis
- 926
- 5
- 9
0
votes
0 answers
full-text search in Microsoft SQL Server
I have a table (name: errors) with lots of rows. some of rows of this table shows in following:
202 16 Invalid type '%s' for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT…
user3582044
- 15
- 4
0
votes
1 answer
When using of full text indexing in sql server give me better performance? In every where or in some situations?
I write a big application by using of NHibernate ORM. Is using of full text indexing in DB level has advantages for my application performance? does it give me better performance in searches?
masoud ramezani
- 22,228
- 29
- 98
- 151
0
votes
1 answer
Lemur gets malformed document error when trying to index file
I've been going through a bit of the lemur indexing tutorial here:
http://www.lemurproject.org/tutorials/begin_indexing-1.php
I've created a "corpus" folder, containing one document with the seemingly properly formatted…
Tristan Havelick
- 67,400
- 20
- 54
- 64
0
votes
1 answer
indexing text resources on windows phone 8
I have about 500 text files (around 6 MB overall) i need to use as resources in my windows phone application.
My application is searching for a string given by the user in the resources and returns the files containing the string to be displayed to…
dagoltz
- 62
- 7
0
votes
0 answers
Sql server Fulltext index Rank features with Datetime
I'm a fresh man in SQL Server Fulltext Index service.
Now I have a PostBody table with 3 columns
(PostID bigint, PostBody nvarchar（max）,CreatedDate datetime2(7)).
I'm using the Table varible function ContainsTable to get the top 100 ranked results.…
DavidPeng
- 53
- 7
0
votes
1 answer
Lucene - Related data in different fields
I want to implement a textual search with Lucene over some documents. The documents are provided already tokenized in a table:
|documentID|token|position|
'documentID' is the id of the document the token is in
'position' describes, on which position…
EarlGrey
- 531
- 7
- 29
0
votes
1 answer
MongoDB: Text index with variable weights
The MongoDB documentation lists this as an example command to add a text index on fields using weights:
db.blog.ensureIndex(
{
content: "text",
keywords: "text",
…
user3336529
- 1
- 1
- 1
0
votes
2 answers
Do voltDB or NuoDB need ElasticSearch?
Currently I am working in a project that use PostgreSQL + ElasticSearch. However I recently found VoltDB, and I was wondering if we still need ElasticSearch for doing searches with VoltDB.
If I am ok, elasticSearch get the data from PostgreSQL of…
Luis Vargas
- 2,466
- 2
- 15
- 32
0
votes
1 answer
ElasticSearch and Python - Correct methodolgy
I am building a search engine for the list of articles I have. I was advised by a lot of people to use elastic search for full text search. I wrote the following code. It works. But I have a few issues.
1) If the same article is added twice - that…
Pratik Poddar
- 1,353
- 3
- 18
- 36
0
votes
0 answers
Strange results of Indexing services
Currently I am working on Indexing services to search document from Windows server. I am using following Query to search "F-0350"
Query
Select rank,Filename,Size,HitCount from Scope() where CONTAINS(Contents, 'ISABOUT('F-0350' WEIGHT(1.0))')
Query…
Prashant Khadatkar
- 200
- 1
- 3
- 18
0
votes
1 answer
XPages create a full text index in SSJS
I have a DB that must be full text indexed, so I added the code below to create one if it is not allready indexed:
if (database.isFTIndexed()){
database.updateFTIndex(false)
} else {
var options:int = database.FTINDEX_ALL_BREAKS +…
Bill F
- 2,057
- 3
- 18
- 39
0
votes
0 answers
Full Text Search not indexing all the words in .msg files
I want to ask you whether in Full Text Search the email documents (with .msg extension) fail to have all their words indexed. I came across this scenario where a particular email that was uploaded in database using FileStream contains 2000 words but…
Andrei Petrut
- 390
- 2
- 15