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 - fulltext-index

SQL Match Against Fulltext Index is slow when searching common terms

Simple PHP search page with three fields querying a MySQL database with millions of rows. The data consists of profiles, mostly USA. Fulltext indexing increases speed by a factor of 9.6 when the searc...
test-img

Ned Hulton

mysql

sql

indexing

query-optimization

fulltext-index

Votes: 0

Answers: 2

Latest Answer

If you could know that the search is on a country name and that you need to look only in the country column, then this would be much faster than any of the above: ... WHERE country = 'canada' What we...
test-img

Rick James

SQL Server Full-Text Search not working on PDF File

My full text search works with doc and docx but not working with pdf. The filters have pdf fullpath: C:\WINDOWS\system32\Windows.Data.Pdf.dll version: 6.2.19041.1023 Tell me what could be the matter? ...
test-img

zig8953

sql-server

full-text-search

fulltext-index

full-text-catalog

Votes: 0

Answers: 1

Latest Answer

It seems that your FileExt column was a bit off, and was adding in the .. So remove the + 1 from it. [FileExt] AS (lower(reverse(substring(reverse([FileAgreementName]),(0),charindex('.',reverse([...
test-img

Charlieface

Posts

Questions

Blogs

Jobs