Tagged Questions
0
votes
1answer
48 views
Can I use the database and query it while full-text indexing?
I need to index my database, but I need to query it while it is indexing, it may take a long time, can I do that?
1
vote
1answer
67 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 ...
0
votes
1answer
61 views
Book / Tutorials / Website - Creating Custom C Database [closed]
I want to create the custom database for my project. Kindly recommend me Good Book or Tutorials or Website which provide the detailed information.
The features want to implement are full text ...
0
votes
1answer
24 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, ...
0
votes
1answer
135 views
Find fulltext indexes in SQL Server 2008
How do I find a list of tables that have a FULLTEXT INDEX applied to them on a given database?
For example, you can enable and disable a FULLTEXT INDEX like this:
ALTER FULLTEXT INDEX ON ...
1
vote
1answer
304 views
SQL Server Full-Text Indexer with stoplists/stopwords
As I'm working on a graduate project (Textmining with SQL Server 2012 Semantic Search) I run into a situation where I need to post a question on this website, hoping someone can help me.
This ...
1
vote
2answers
243 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?
...
0
votes
0answers
254 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 ...
3
votes
2answers
299 views
Slow ORDER BY with LIMIT
I have this query:
SELECT *
FROM location
WHERE to_tsvector('simple',unaccent2("city"))
@@ to_tsquery('simple',unaccent2('wroclaw'))
order by displaycount
I'm happy with it:
"Sort ...
3
votes
1answer
706 views
Postgres full text search with multiple columns, why concat in index and not at runtime?
I've come across full text search in postgres in the last few days, and I am a little confused about indexing when searching across multiple columns.
The postgres docs talk about creating a ts_vector ...
2
votes
1answer
936 views
Best way to compare strings using pre-built ngrams?
I'm struggling with an n-gram problem and have been hunting the Web for examples to help me out and have noticed n-grams being discussed on this forum. I'm working on a system where we've got scraped ...
1
vote
1answer
531 views
At which frequency run CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on a fulltext index?
I've been told to run periodically CTXSYS.CTX_DDL.OPTIMIZE_INDEX(...) on some fulltext indexes, with no more information, in particular at which frequency this task should be run.
I guess that it ...
0
votes
1answer
91 views
Where I can find articles or resources explain MySQL Fulltext index? [closed]
I want to understand MySQL index and Fulltext index. Where can I find resources to help me understand it? Or can you help understand MySQL indexing mechanism?
2
votes
2answers
251 views
What does “GIN doesn't support full index scans” mean?
I'm a RDBMS newbie and I have a PostgreSQL database of more than 50 millions lines, growing everyday. There is a column 'text', which contains human-generated text of around 20 words. I need to be ...
