Hi there,
I'm wondering how larger BLOBs in a database affect performance of accessing
the non-blob data. We've got a database with potentially a few million
records in the main tables (of just strings and ints), but joined to that data
set we want to store up to thousands (maybe 75000 max)
On Tue, Mar 2, 2010 at 10:54 AM, Paul Vercellotti wrote:
> Now I'm guessing that storing all those blobs will slow down access to the
> main tables (assuming records are added gradually - most without associated
> blobs, some with), because records would be spread out over many more pages
> (more
Hello Paul,
My experiences with blobs suggests it's better to keep them in a
different DB file. My uses sounded very similar to yours, tables of
normal data interleaved with blob inserts. The physical process of
having to move from page to page seems to be the bottleneck, not
Sqlite itself. I was
3 matches
Mail list logo