-------------------------------------------------- From: "Douglas E. Fajardo" <dfaja...@symark.com> Sent: Monday, May 18, 2009 12:25 PM To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>; "AllenFowler" <allen.fow...@yahoo.com> Subject: Re: [sqlite] Sqlite as a FIFO buffer?
> One thing to watch out for - using SQLITE for a FIFO will have limited > throughput, because commits will have to be done after inserting or > removing each entry. This might not be an issue in some situations - I > have actually implemented a FIFO to communicate between two tasks where > the work-per-entry was significant, the transaction rate was low, and the > protection against accidental loss was paramount. > > *** Doug F. > > I have seen this. I have two other tables where the inserts can take up to 1 second to do. For my application this is acceptable. The events themselves are queued and there is enough idle time between jobs to catch up if needed. Is there a better way to do this? Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users