On Thu, Sep 17, 2015 at 9:41 AM, R.Smith <rsmith at rsweb.co.za> wrote:
> > > On 2015-09-17 02:22 PM, Richard Hipp wrote: > >> On 9/17/15, John McKown <john.archie.mckown at gmail.com> wrote: >> >>> Well, this may be a heretical answer. >>> >> Yes, it is. >> >> ?<snip>? ?<snip>? > (11) This forum. Need help or suggestions with how to optimize your > internal value-store? Not so easy. Need help optimizing an SQLite DB or > query? We've all seen the very clever people here always eager to assist. > It's an amazing and very valuable resource. (This one is also true for > other community-supported DB systems in general) > > > Cheers, > Ryan > > ?OK, I did really put my foot in it. [grin/]. I do that often enough to not be upset by it. But it did result in the OP doing a test and realizing that the problem was _not_ data access, but apparently elsewhere in the code. I'm a bit of an pro-SQL person myself. Especially when doing things which require joins & CTEs! I trust the SQL people's code a lot more than I trust my own (I'm a sysadmin who can program, but not a professional programmer). But it is not _always_ the "one true way". This would be more for "unstructured" data. But, then, I need to be reading up on FTS so I could well be wrong on this point too. -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
