Re: database abstraction layer
| From: | Rene Veerman | Date: | Wed, 03 Feb 2010 05:39:29 +0000 |
| Subject: | Re: database abstraction layer | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-301779@lists.php.net to get a copy of this message | ||
On Wed, Feb 3, 2010 at 5:49 AM, Jochem Maas <jochem@iamjochem.com> 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.