Hi, please excuse me for the title, I'm seeking some ideas as to how to do the following. I'm running a mod_perl script in linux/apach2. When a client accesses the script, it reads from a large mysql table, and hands out a row from that table. I'd like it so that different clients get different records. What I have done is to have a column in the table to mark it as "used" whenever it hands out. Of course, the problem is that when many clients are accessing it at about the same time, there is a racing condition. What is the best way to do this? I'd like this to be efficient. I can create a lock on a file and force sequential access, but not sure how efficient that is. Also the table is pretty large, I'd like to avoid querring the table each time a client accesses, so I'm thinking of getting a chunk out at a time, say 100 records, but then how do I share them among different sessions? Thanks.

In reply to mod_perl: locking and sharing between sessions by johnnywang

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.