|
Posted by Bobus on 02/14/06 06:00
Hi,
I have a table which contains a bunch of prepaid PINs. What is the
best way to fetch a unique pin from the table in a high-traffic
environment with lots of concurrent requests?
For example, my PINs table might look like this and contain thousands
of records:
ID PIN ACQUIRED_BY
DATE_ACQUIRED
....
100 1864678198
101 7862517189
102 6356178381
....
10 users request a pin at the same time. What is the easiest/best way
to ensure that the 10 users will get 10 different unacquired pins?
Thanks for any help...
Navigation:
[Reply to this message]
|