My application is running 24x7 with huge data loads and around 10 open
connections all the time.

On Dec 19, 2007 4:50 AM, Renaud HUILLET <[EMAIL PROTECTED]> wrote:
>
> I have that for my soft and it works fine.
>
> I also have a swap mecanism to update the sqlite file : the daemon gets the 
> sqlite file's name from a filemapped into memory.
> When a new file has been generated, another batch updates the filemap with 
> the new sqlite file's name.
> The daemon sees the file name has changed (with no I/O since it is mapped 
> into memory) , kills the SQLIte connection and opens a new one.
>
> Best Regards.
> Renaud> Date: Tue, 18 Dec 2007 14:27:28 -0800> From: [EMAIL PROTECTED]> To: 
> [email protected]> Subject: [sqlite] sqlite in a daemon> > Hello,> > I 
> am considering writing a daemon that would keep the sqlite connection opened 
> forever (at least in the "daemon" sense of forever). Is it a good idea? Any 
> experience you could share about that kind of design?> Thanks> > > > > 
> ____________________________________________________________________________________>
>  Looking for last minute shopping deals? > Find them fast with Yahoo! Search. 
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to