[Lazarus] Embedded/small database

[Henry Vermaak]

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