Most languages have the ability to kick off different threads that run in the background. You can have a writer thread that dumps the queue and then sleeps for another minute and then continues the loop. I don't know PHP, but a quick search found that it does have a Thread class which I presume could be used for this purpose. If you need more help on implementing that part I'm sure a PHP-specific mailing list would be able to provide better assistance.
HTH, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: FredAt [mailto:[EMAIL PROTECTED] Sent: Friday, November 16, 2007 10:17 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Would SQLite be a good choice Thank you! I like the idea of batching the writes and dispensing with the intermediate flat file. However, it is not clear to me where I would run the dequeuer from. The only thing I can think of is running the dequeuer as a PHP script which I arrange to call every few minutes. I can certainly do this from one of my development machines and there is probably a way to run the script directly on my server but I don't know of that. What did you have in mind? ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
