Re: [PHP] database abstraction layer
[email protected] (Rene Veerman)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Feb 3, 2010 at 5:49 AM, Jochem Maas <[email protected]> wrote: > you can bet you ass that every other DB out there that's worth it's salt > has atomic id incrementor functionality exposed in some way or other. > > @Rene: all that talk of maxId functions and random retries etc, etc, is complete pooh. > don't do it, **please** use the proper tools provided by the DB in question. > i just checked how my 1 app that did generate over a million hits/day (all with an insert for stats purposes) for a few weeks handles the getMax issue, and i see i did use mysql's auto_increment there. i suppose the difference in syntax between sql servers for this one is acceptable.