[sqlite] Slow deletion

2010-06-11 Thread durumdara
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

Re: [sqlite] Separated transactions - stable consistency

2006-04-19 Thread DurumDara
[EMAIL PROTECTED] írta: DurumDara <[EMAIL PROTECTED]> wrote: I want to use SQLite database like the FireBird database: with big isolation level. SQLite transactions are SERIALIZABLE. It is possible to force SQLite transactions to be READ UNCOMMITTED under some special circums

[sqlite] Separated transactions - stable consistency

2006-04-19 Thread DurumDara
Hi ! I want to use SQLite database like the FireBird database: with big isolation level. What's that meaning ? I have an application that periodically check some input directory, process the elements in it, and copy them into a global database. It is like a daemon, working in the background. Th