[sqlite] ROWID-based queries slow in FTS db

Hi all, I'm using FTS through DBD::SQLite (perl) to query large text databases (~10GB, ~10 million records). The regular FTS MATCH searches work fine (they usually run under a second), but searches based on ROWID are atrociously slow and hog massive amounts of memory. I'm trying to retrieve a c

Re: [sqlite] ROWID-based queries slow in FTS db

Thank you for the quick fix and the info, I will wait for 3.8.9 to trickle down into DBD::SQLite. AF Dan Kennedy írta: >On 01/30/2015 10:49 PM, Dominique Devienne wrote: >> On Fri, Jan 30, 2015 at 4:38 PM, Dan Kennedy wrote: >> >>> On 01/29/2015 02:29 AM, farkas andras w

[sqlite] FTS5

Hi all, I found a previous FTS5 thread and, encouraged by the comments of Dan Kennedy, thought I would comment on the issue. - Smaller memory footprint and more speed is always great. I'm already very impressed with the speed but even faster is even better of course. My experience is that search