The full-text-search tag has no wiki summary.
2
votes
3answers
67 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 ...
1
vote
0answers
27 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
251 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
66 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
71 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.
...
0
votes
0answers
74 views
Sql Server 2008 Full Text Seach performance issues
We have the following setup for an web application:
Server
Intel Xeon E5606 @2.13GHz (2 processors - quad core)
24GB RAM
Software
SO: Windows Server 2008 R2 Standard (SP1) x64
Microsoft SQL ...
6
votes
0answers
96 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
38 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 ...
1
vote
4answers
147 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
117 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
87 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
142 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
117 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
191 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
1answer
204 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
368 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 ...
0
votes
2answers
111 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
144 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
125 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
85 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
439 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
250 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
121 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
350 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
267 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
312 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
370 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
1k 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
439 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
247 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
233 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, ...
0
votes
1answer
1k views
lucene vs sphinx vs xapian vs lemur , which is a good choice for production use?
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
216 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
375 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
2k 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
310 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
321 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
583 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 ...
2
votes
2answers
350 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
361 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' ...
5
votes
3answers
4k 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 ...
