Good lord that is exacty the same logic applied in our app. It only takes about 100 users to create the issue.


Sent from my iPod

On Feb 2, 2010, at 6:05 PM, Rene Veerman <> wrote:

i haven't had the pleasure yet of writing for sites that generate so many
hits/sec that
they'd update the max value of any table at exactly the same time.

i usually ask for the max value about 2 milliseconds before doing the
And if the insert fails, i can auto-retry via a wrapper function after
I dare say i could work this way at facebook <g> (not that i really want to,
happy with where i am)

On Tue, Feb 2, 2010 at 11:46 PM, Ashley Sheridan

On Tue, 2010-02-02 at 23:19 +0100, Rene Veerman wrote:

function getMax($table, $field)

If I saw this sort of code I'd be appalled! It's possibly the worst way to get the auto increment value. You won't notice it testing the site out on your own, but all hell will break loose when you start getting a lot of
hits, and two people cause an auto increment at the same time!


PHP General Mailing List (
To unsubscribe, visit:

Reply via email to