Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.
1
vote
2answers
264 views
Slow insert with MySQL full-text index
I use a full-text index in a MySQL table, and each insert into this table takes about 3 seconds. It seems that MySQL rebuilds (a part) of the full text index after each insert/update. Is this right?
...
3
votes
1answer
30 views
Fulltext stoplist replication
In MS SQL Server 2008 R2 there is replication of table with fulltext index on it.
But stoplist that is associated with replicated fulltext index doesn't replicate.
Is there any possibility to ...
2
votes
1answer
49 views
MySQL Full Text search increase relevance for exact matches?
I have a MySQL database of ~10,000 organisation names that I want to be able to search. I would like to use a full text search because this would enable me to find "institute of doobry" by searching ...
1
vote
1answer
73 views
I would like to query a range of criteria on multiple columns in MySQL
I have 3 columns in a mysql table. I'm using Innodb engine. I want to be able to search for some values on those columns and also anything close to those values. For example :
We have 3 columns as ...
1
vote
1answer
63 views
Avoiding performance hit from GROUP BY during FULLTEXT search?
Is there any clever way to avoid the performance hit from using group by during fulltext search?
SELECT p.topic_id, min(p.post_id)
FROM forum_posts AS p
WHERE MATCH (p.post_text) AGAINST ('baby ...
0
votes
1answer
19 views
Searching for keywords in fulltext indexes using the “contains” function
Lets assume "and" is not a stopword, in my language it should not be.
How do I search for it using the contains function?
It is a keyword, but how do I escape the keywordness?
No luck with:
SELECT ...
0
votes
1answer
26 views
Which text-index I should create for xooops engine to achieve better search results?
In one of projects we use xoops engine to manage content. In mysql slow query log most of queries are following :
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, ...
3
votes
0answers
34 views
Full-text search with german umlauts
I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.
The ...
3
votes
0answers
31 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
2
votes
0answers
25 views
Combining full-text-search queries
I have two tables in a SQL Server database with basic fulltext indexes:
CREATE FULLTEXT CATALOG table1_catalog;
CREATE FULLTEXT INDEX ON table1
(
name1
)
KEY INDEX pk_table1
ON ...
2
votes
0answers
73 views
How do I get more details on a full text catalog error?
I have an error that is repeatedly generated on a SQL Server 2005 instance running the databases for MS Team Foundation Server.
'Severity 16' occurred on INSTANCENAME
Looking in the SQL Server ...
2
votes
0answers
39 views
improving this goal query
Goal
joining the two tables: tbl_quickSearchParam (fulltext search results) against tbl_product ( active products : prod_status = 1, group by prod_image_name)
create table tbl_product (
...
2
votes
0answers
80 views
SQL Server fulltext_semantic_languages
When trying to install a semantic search example, I'm running into a problem.
There are some steps in the example to check if the 'new' Semantic Search and Full Text Search are installed.
...
2
votes
0answers
194 views
SQL fulltext accent insensitive
I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the ...
1
vote
0answers
14 views
Fulltext search limiting users possibilities
We have a web site with a search box. The search uses a fulltext index column. However, we just cant feed the text the user has input into this stored procedure.
CREATE PROCEDURE [dbo].[SearchPages]
...
1
vote
0answers
153 views
sql server full text search - fuzzy searching?
Is there a way to configure fuzzy searches in sql server full text search. Meaning if I search for a term called POWDER, I must get matches (i.e. strings) which contain any variations of it within an ...
1
vote
0answers
31 views
Fulltext indexes and issuers with server startup
I have a windows server for host about 4500 data bases for same application. And this application have 34 fulltext catalogs on it, and the CHANGE_TRACKING for this fulltext index are AUTO.
And the ...
0
votes
0answers
15 views
Full text search on multiple tables in PostgreSQL
I have several tables that have related data. I want to have a search input box on the dashboard of the system that will search for anything (client, invoice, delivery note, ...).
Is it possible to ...
0
votes
0answers
34 views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
0
votes
0answers
44 views
mySQL- large database
I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such ...
0
votes
0answers
37 views
Full-text search index size
Is there any analysis about this topic? For example what is the estimated index file size of 1 GB .txt files?
0
votes
0answers
13 views
Which triplestores have support for full-text search
Which RDF triplestores support full-text search and what performance can be expected from them.
I am assuming that they will have to extend SPARQL in some way as the only way that I can think of for ...
0
votes
0answers
155 views
Slow INSERT INTO SELECT statement – not repeatable!
Short Version:
INSERT INTO SELECT into a table with fulltext index with the same data takes sometimes 25 seconds and sometimes 2500 seconds. We have no idea where this huge gap is coming from.
Long ...
0
votes
0answers
266 views
Having trouble creating a unique key for full-text index on an indexed view in SQL Server 2008r2 and I am not sure if the string length is the cause
I am having trouble creating a unique key for a full-text index on an indexed view. My definition is as follows:
CREATE VIEW [dbo].[vw_inventory_metadata] WITH SCHEMABINDING AS
SELECT ...
0
votes
0answers
111 views
Does full text search allow partial world
Say I want all restaurants that contain sushi
My user search for sus, ush, and shi
Now I want mysql to efficiently find rows whose title or description (or whatever) contain sus, ush, and shi, ...
0
votes
0answers
78 views
Database structure advice for large data text searching
I want to search scanned text (comprised of a few gigabytes of text).
The problem with this text (which is why I cannot make an index of words) is that it was OCRed, so there could be (and are) ...
0
votes
0answers
122 views
What's is WITH QUERY EXPANSION MODE in MySQL Fulltext Search
MATCH (col1,col2,...) AGAINST (expr [search_modifier])
search_modifier:
{
IN NATURAL LANGUAGE MODE
| IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
| IN BOOLEAN MODE
| WITH QUERY ...
