Hi! I have an app that transform the input images to later somebody can choose the final version.
I stored them in an SQLite blob table: create table blobs( filename varchar(255) not null, ext varchar(3) not null, size integer not null, primary key(filename, ext, size)) In the prior version of the program I used PGSQL for it, but this was extremely slow with bytea fields (the deletion was 1-2 hours sometimes). After this I used AnyDBM, but this don't useful: after 2 GB the inserts are very slowed down... In SQLite the insertion, select is good. But deletion also slow. In an 268 MB size db the "delete from blobs" is 1-5 minutes, the drop table blobs also... :-( 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? Thanks: dd _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
