python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - full-text-indexing

sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value

I am working with an SQLite3 database. And I want to create an FTS5 content-less (content="") or content="external table" table to save space and prevent duplication of data (which...
test-img

Pankaj

database

sqlite

full-text-search

full-text-indexing

Votes: 0

Answers: 2

Latest Answer

Create a contentless fts5 table: CREATE VIRTUAL TABLE IF NOT EXISTS fts_tbl USING fts5(a, b, c, content='') Create triggers so it updates as your table you want indexed updates: CREATE TRIGGER IF NOT...
test-img

ToBeFrank

MySQL fulltext index: how to disable stopwords

Many users are going to search my InnoDB MySQL database for terms like "The Gap", "BT group" or "IG Index" etc. I don't want to annoy them with "zero results". ...
test-img

Ned Hulton

mysql

indexing

innodb

full-text-indexing

Votes: 0

Answers: 1

Latest Answer

Seems to be working now: as @Shadow pointed out, you need to set the variable globally. So: Added this to my.cnf file: innodb_ft_min_token_size=2 ft_min_word_len=2 ft_stopword_file = "" And...
test-img

Ned Hulton

MySQL Match Against: easiest way to deal with stopwords

I get zero results from this query: SELECT COUNT(1) FROM `myTable` WHERE MATCH(tagline) AGAINST(' +IT professional' IN BOOLEAN MODE) I get 92 from this: SELECT COUNT(1) FROM `myTable` WHERE `tagline`...
test-img

Ned Hulton

mysql

sql

indexing

full-text-indexing

Votes: 0

Answers: 1

Latest Answer

If innodb_ft_min_token_size is the default of 3, then IT is "too short" (as opposed to "a stopword"). Further note that +IT insists on IT, but, since IT is totally ignored, it is ...
test-img

Rick James

Optimizing SQL Server Table Valued function with Full Text Search tables

I have been trying to analyse and optimize a runtime spike in a stored procedure in SQL Server 2014. Background of the DB objects I found that the stored procedure shows a spike in runtime when there ...
test-img

DJs

sql-server

full-text-search

query-optimization

full-text-indexing

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs