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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
