[yunqa.de] Re: Large Blob Performance Issues
- From: David Michael <davidrm@xxxxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Tue, 14 Jun 2011 21:51:45 -0500
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
Other related posts:
