Not an answer to your question but:

You could look into getting rid of the database and instead setting up something similar to a mail folder, say Maildir. As this was designed for use with email which has many of the same traits of your problem it should work just fine. As many of the files will be cached in RAM doing this there should be no real performance penalty either due to disk access.

Maildir does not work on Win32 due to the filenames used, but something similar should be possible.

You could have a seperate folder for each client gaining you the security mentioned above. Backups would also become very simple. Of course if the daemons are on a different machine to the files then...

--tidiness is the memory loss of environmental mnemonics

In reply to Re: Database poller by EvdB
in thread Database poller by Marcello

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.