Re: [PHP] database abstraction layer
[email protected] (Phpster)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
Good lord that is exacty the same logic applied in our app. It only takes about 100 users to create the issue. Bastien Sent from my iPod On Feb 2, 2010, at 6:05 PM, Rene Veerman <[email protected]> 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 > insert. > And if the insert fails, i can auto-retry via a wrapper function after > sleep(rand(1,3)); > 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 > <[email protected]>wrote: > >> 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! >> >> Thanks, >> Ash >> http://www.ashleysheridan.co.uk >> >> >>