Re: [sqlite] How efficiently will SQLite work as a queue?
Andrew Shakinovsky wrote: I am looking at the PRAGMA auto_vacuum command. How efficient is this (as far as time is concerned. I am not concerned about space)? Autovacuum makes the database a little larger (by a few percent) and it makes DELETE operations a little slower (by about 20%, IIRC). More details are forthcoming. Autovacuum is a new feature for version 3.1 which has not yet been released. -- D. Richard Hipp -- [EMAIL PROTECTED] -- http://www.hwaci.com/drh/
[sqlite] How efficiently will SQLite work as a queue?
I am contemplating using SQLite as a message queueing mechanism, and was wondering whether this would be efficient. In particular, I will be adding new records to a table, while another process removes those records when it is ready to handle that "message". My question relates to possible fragmentation that may occur within the database file as records are deleted. Will SQLite efficiently reclaim the space used by the deleted records? I am looking at the PRAGMA auto_vacuum command. How efficient is this (as far as time is concerned. I am not concerned about space)?