[Lazarus] Embedded/small database

Henry Vermaak henry.vermaak at gmail.com
Tue Feb 17 16:26:13 CET 2015


On Tue, Feb 17, 2015 at 07:54:00AM -0700, leledumbo wrote:
> Tested, it can't even manage 50,000 rows efficiently. Searching a
> string takes minutes, while it takes a fraction of second in real
> dbms.

Interesting.  I've seen benchmarks where sqlite query times for a
full-text search on 120000+ rows is less than 20ms.  Did you use FTS4
for your search index?

Lucene was the only embedded database that could beat sqlite for
full-text search, IIRC.

Henry




More information about the Lazarus mailing list