On Fri, 11 Jun 2010 00:49:47 -0700 (PDT) durumdara <[email protected]> wrote:
> Hi! > > I have an app that transform the input images to later somebody can ..... > I increased the size of pages, but only a little changes I see. > > May this caused by index? Because this is a primary key, I cannot drop > it... > > What can I do to improve the speed on blob deletion? > a) Make a database exclusive for BLOB and use ATTACH from the principal database. b) Add to BLOB-only database table a new colum Boolean with name "dirty" c) When add blobs set dirty to false. d) Don't delete any blob entry, just set the dirty value to true. e) When you do any select on this table check dirty=false too. f) Do one of this options when you can (idle or maintenance time) f1) Delete from blobtable where (dirty=true) f2) select * from blobtable where (dirty=false), copy to another db, table or temp table, drop db or drop/truncate blobtable. You can also index the blobtable by dirty colum for faster searches, don't know if > Thanks: > dd HTH > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
