Just a quick addendum...Increasing the pagesize of the database actually doesn't increase the DB file size as much I first thought. The DB gets bigger, but not at the rate I was worried about.
And the bigger pagesize does have a nice impact on large blob saving (and on loading).
I'm not familiar enough with SQLite, though, to know if ratcheting the pagesize up like this is a *good* idea.
Again, any information/suggestions appreciated. Thanks. -David On 6/14/2011 9:01 PM, David Michael wrote:
I'm currently evaluating DISQLite3 as a replacement for the DB in my desktop application. One requirement I have is to be able to handle large blobs, 10-15MB. From experimenting, anything over 2MB or so tends to suffer. Not so bad on loading (though not great either), but saving takes seconds. This is true whether I do a single "traditional" blob binding, or the "incremental" approach. Traditional is actually slightly faster. I found I could improve performance some by increasing the PageSize, but that has a predictable (and significant) impact on the size of the DB file. I'm looking other suggestions for improving saving & loading of large blobs. Any help would be appreciated. Thanks! -David _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa
_______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa