subject:"\[sqlite\] BLOBs' affect on DB performance"

Re: [sqlite] BLOBs' affect on DB performance

2010-03-02 Thread Teg

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

Re: [sqlite] BLOBs' affect on DB performance

2010-03-02 Thread Max Vlasov

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

[sqlite] BLOBs' affect on DB performance

2010-03-01 Thread Paul Vercellotti

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)