Support for Full Text Indexes and search

+4 votes

The search functionality in dbFront uses LIKE which can causes table scans. This performs very poorly on large tables. It would be great if dbFront could support the Full-Text indexes available in all of the database servers (SQL Server, Oracle and MySQL).

This would be relevant for both the Advanced and the Quick/Simple searchs.

in Features (Todo) by (4.6k points)

1 Answer

+1 vote

Supporting Full Text search would definitely help with performance on very large tables. This will be marked as Enterprise functionality.

NOTE: Please vote on this Feature Request if it interests you.

by (52.4k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer