The full-text-search tag has no wiki summary.
0
votes
0answers
47 views
Elasticsearch and couchdb river indexing slows down after a few hours
Trying to import ~400m docs in to Elasticsearch from couchdb using the couchdb river plugin. Everything starts out great with indexing time around 5k/s but after a few hours come back and find its ...
0
votes
0answers
30 views
limiting indexed size of files in solr
I want Solr to perform indexing only for the first X KBytes of each file. E.g. if I have, let's say, 10MB document, I want Solr to scan only the first 500KB and ignore the rest of the file.
Is there ...
0
votes
0answers
60 views
full text search in dovecot with substring matches
Is there any working method/implementation of enabling full-text search in Dovecot v2.1 which would enable search of substrings?
Options currently offered by Dovecot:
- squat - deprecated and causes ...
2
votes
0answers
100 views
Sphinx searchd: failed to lock .spl file, no such file or directory
I use sphinx for indexing on my development environment, and it is working fine. But when i take it to the server. I can index and I have the indexes with search working on them, but everytime I run ...
0
votes
1answer
68 views
Is there any way to store the index of a network file system (SMB 2.0) on the server, so that my users don't have to manually set up the index?
I apologize if this is in the wrong place, but I believe it is sufficiently server related. Also, just as a disclaimer: I'm not the server guy! I'm just trying to find out information.
I have several ...
0
votes
0answers
128 views
SQL Server missing .eml IFilter
I am having trouble with my IFilters in SQL Server 2012 with FullText Search enabled on my FileTable. I recently imported keep emails in .eml format using a C# application. I noticed my fulltext ...
0
votes
1answer
83 views
Add a web based document search to my debian fileserver
I have a Samba-based fileserver with lots of gigs of data on it, mostly Word, Excel, OpenOffice and PDF documents.
I've set up a simple web based search interface (Apache, PHP, mlocate) that just ...
3
votes
3answers
202 views
Simple full-text search server
I have been looking at search solutions like Sphinx, Solr and Elasticsearch but they are all way too complex for what I need.
I'm basically looking for a server software, best distributed, that ...
2
votes
0answers
106 views
Full Text Search query elapsed time varying wildly
Database Version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
0
votes
3answers
506 views
Mysql full text search cause high usage CPU
We built a news site. Every day we will input tens of thousands data from web api.
In order to provide a precision search service, our table use MyISAM, build fulltext index (title, content, date). ...
0
votes
2answers
176 views
High MSSEARCH Wait Type in SQL Server 2005
This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem.
The server had been running with no problem for several weeks until the other ...
1
vote
1answer
291 views
MySQL - Changing FT_MIN_WORD_LEN (my.ini)
I've recently asked my server administrator, for my Windows dedicated server, to change the MySQL configuration file (my.cnf) to allow search words of 2 characters or more, from the default of 4.
...
7
votes
1answer
269 views
Mysql change ft_max_word_len bug
So, I have MySQL installed on my machine, and I need to change the ft_max_word_len, the maximum word length that MySQL will index. However, when I set it up via the tools provided, and query it, it ...
0
votes
1answer
70 views
Livelink ECM 9.x. Why Full Text Search Doesn't work for my document
Please explain me how does Full Text Search work in OpenText Livelink ECM?
When I add Microsoft Word document to a folder "Full Text Search" doesn't find it though queried word is the only word in a ...
2
votes
4answers
374 views
Full text search for more than 30,000 MS Office documents
We have more than 30,000 MS Office and PDF documents in Windows shares on Windows Server 2008 R2. What possibilities do we have to get full text search on all of these documents?
It's important that ...
1
vote
2answers
199 views
MySQL and cardinality of index
I have a MyISAM table in a MySQL database on an Ubuntu 10.04 server with 256mb RAM. Maximum packet size is 32mb. The table has 150,000 rows.
The table has three columns, two of which are TEXT type. I ...
1
vote
1answer
113 views
MySQL deadlocks when trying to drop large fulltext index
I'm trying to just drop a 500mb fulltext index on an older 4.1 MySQL MyISAM table.
When I do it, the cpu pegs to 100% and sits like that for over 10 minutes.
This cannot be normal, right? I gave up ...
0
votes
1answer
239 views
Ideas for doing large-scale full-text search on high-insert MSSQL database
I've got a reasonably large MSSQL database with a table of about 6 million rows and around 50k inserts daily. One of the things I'm starting to struggle with is fulltext search, as I've a requirement ...
1
vote
1answer
205 views
Windows Search Service causing too many accessed files
I am trying to more closely audit my users access of files located on a file share. The files share is served by a server running windows server 2008 R2 and running the Windows Search Service. I am ...
1
vote
1answer
325 views
How to add full text feature to already installed SQL Server Express 2008
I have an installed version of SQL Server Express 2008 but it does not have the full-text service. Short of uninstalling and re-installing the Advanced Services version, what is the easiest way to add ...
0
votes
2answers
354 views
Failed to install Full-Text Search on SQL Server 2008
I'm trying to upgrade my SQL Server 2008 with Full-Text Search feature. Installation fails on it's very end with something like this in C:\Program Files\Microsoft SQL Server\100\Setup ...
2
votes
2answers
610 views
Why is this MySQL FULLTEXT query returning 0 rows when matching rows are present?
I have a MySQL 5.5.4 table with >200M rows which has a FULLTEXT index on two columns (Title,Body).
When I do a simple FULLTEXT query in the default NATURAL LANGUAGE mode for some popular results ...
1
vote
2answers
152 views
Slow Search since moving from 2003 Server to 2008 R2
I moved a client from a old Windows 2003 server to a new fancy Windows 2008 R2 box. I have been able to get everything to work properly except for the search function inside a program called Invoice ...
1
vote
2answers
223 views
SQL Server Full Text Search resource consumption
When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU)
Similarly when you perform full text searches, resources are consumed.
How can I get a gauge over a 24 hour ...
0
votes
1answer
155 views
search options based on data
I write an example to be more practive.
I need to know if it is possible to next search based on the data I have in my database, fulltextsearch engines in sqlserver-2008 or Apache Solr:
Case 1:
Data ...
1
vote
0answers
110 views
Adding new word characters to UTF8 encoded mySQL table for a fulltext search
I have found in the docs where it describes how to add characters to the list of word characters used during fulltext searches. My table is encoded UTF8 and from what I can see, there isn't a ...
1
vote
1answer
792 views
SQL Full-Text indexing not populating
We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
0
votes
2answers
372 views
MySQL hangs and table inaccessible after adding fulltext index
After adding a fulltext index to one column in a table with 30,000 rows that table is now inaccessible. Any attempts to modify, drop, truncate, or access it hang. MySQL also reports that the user has ...
1
vote
0answers
171 views
Alter Fulltext Catalog Reorganize: Any issues to run this during daytime?
I have been going thru documents on Alter Fulltext Catalog Reorganize.
But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
0
votes
1answer
418 views
How much to increase page file value for SQL Server 2008 R2 Full Text Search Engine
SQL Server 2008 R2 Full-text search engine (FTS) is taking up too much resource (I/O & Memory) in my production server. (migrated from SQL server 2005).
I have been reading up on SQL Server FTS ...
1
vote
1answer
301 views
Adding features to an SQL Server 2008 standard with SP1
I have MS SQL Server 2008 with SP1 installed.
I want to add the Full text feature to the installation.
Do I need to run the SP1 update again after I add this feature?
If I do try to run it ...
1
vote
3answers
364 views
grep/search for multiple lines in a file
Let's say I have a file with a long nested array, that's formatted like this:
array(
'key1' => array(
'val1' => 'val',
'val2' => 'val',
'val3' => 'val',
),
...
1
vote
0answers
396 views
How to create full-text catalog as default catalog?
This would save me the redundant ON MyCatalog phrase when I create full-text indices.
For example,
CREATE FULLTEXT INDEX ON MyTable
(
MyField1,
MyField2,
MyField3
)
KEY INDEX PK_MyKey ON ...
1
vote
1answer
2k views
How to get permission to create full-text index?
I tried to create a full-text index on my new full-text catalog and got this error:
Msg 9967, Level 16, State 1, Line 1
A default full-text catalog does not exist in database 'foo' or user does not ...
0
votes
1answer
655 views
What can cause SQL Server Full Text Indexing automatic change tracking to stop working?
On a SQL Server 2008 server, we have a full text catalog in a database. The catalog is set to "track changes: automatic".
What can cause this to not work sporadically, so the index is not updated?
0
votes
2answers
1k views
How do you find the name of an existing full text catalog in SQL Server 2008 Express?
I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the ...
1
vote
3answers
331 views
How do you do a keyword search the Services.msc (mmc) window in Windows 7?
When you want to run a service, you have very limited capabilities, in all current Windows versions, as far as I can tell.
I usually start Services by typing "services.msc" into the Start->Run box, ...
-1
votes
1answer
1k views
lucene vs sphinx vs xapian vs lemur , which is a good choice for production use? [closed]
I am evaluating the full-text searching systems and I really need your practical experiences. Also you can suggest some that I didn't mention.
2
votes
2answers
295 views
What is the big difference between Fulltext-Search on SQL2000 and SQL2008
my first test to get a given database with activated fulltextsearch running on a sql2008 failed with the result that it creeps.
sql2008 took several the time of sql2000, but why?
0
votes
1answer
429 views
Enabling DB2 Database for Full Text Searching
I'm trying to enable full text searching on a DB2 V9.5 database, SuSe Enterprise Linux.
Net Search Extender has been installed and db2text service starts without problems.
When I execute the ...
2
votes
2answers
3k views
Installing SQL Server 2008 Express Edition with Fulltext Indexing
According to this page, SQL Server 2008 Express Edition with Advanced Services includes Fulltext search:
http://www.microsoft.com/express/sql/download/
However, I downloaded it, ran it, and I see no ...
2
votes
1answer
362 views
Full-text catalog timeout, SQL Server 2005
we are re-loading a db with new data using backup/restore process. Once restore is complete, we re-build the full-text catalog. Full text searches work, no timeouts for about a day or so. However if ...
0
votes
1answer
391 views
How do I modify the thesaurus for full-text-indexing in SQL 2005?
So I've read this:
http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
And I've made the following modification to the tsENU.xml file to include the ...
1
vote
2answers
766 views
MySQL Fulltext 3 letter limit
We have a site thats using MySQL fulltext searching but has an issue that a number of strings that need to be indexed are 3 characters long. I know that the default for MySQL is not to index strings ...
3
votes
2answers
501 views
Local full text index for a directory tree, a quicker alternative for grep -R
I have a large directory tree of source files. I want to search around all these files. My first instinct is to use grep -R or ack, but either way they just sequentially read all the files.
Is there ...
0
votes
1answer
410 views
IIS6 Indexing Service indexing asp.net codebehind (.aspx.cs) files
I've setup a few catalogs on an Windows Server 2003 IIS6 install, each tracking files within a website. In the Properties -> Generation Dialog for each catalog, 'Index files with unknown extensions' ...
6
votes
3answers
6k views
How to detect if full text search is installed in SQL Server
I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and ...
