Contributed by BBQ
on Apr 23, 2000 at 05:15 UTC
> dates and times
For a long time I've used time() as a primary key on small
databases just to keep track of records' ages. The problem
is: what do I do if I have more than 1 transaction per
second? Is there any perlfunc that will let me get less than
a full second reply?
|Answer: time() smaller than seconds?|
contributed by turnstep
It's probably easier to just add something else to your
primary key than to try and get sub-second responses. A
good example is to use:
which sets the key to a combination of the time
in seconds and the process ID. This combination
will be unique, as long as each time the script is
run it generates a single key (e.g. a web script).
If the script generates more than one key per second,
add a counter:
$mykey = "$^T$$";
$mykey = "$^T$$" . $x++;
If you do need sub-second times, you can look
at the Time::HiRes module, although it may not
work on your system, as it uses syscall
in C. Probably easier overall to use the
Please (register and) log in if you wish to add an answer
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:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||