Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Eloi G. <el...@re...>]

> Hmmm. There might be a way around this.
>
> Say we create our OWN sequencer.
>
> table : core_sequencer
> -----------------
> column : table_name
> column : primary_key_name
> column : current_id

Gotta give a -1 on this one.  While it is a really elegant solution to the
table spawn problem, it becomes a bottleneck when your site breaks into the
mainstream.  It's one thing when you have 20 queries + 5 inserts per second
on various tables in your database.  But if each of those inserts also
requires a table lock on the core_sequencer, the entire site will get bogged
down really fast.

I know I'm coming in too late in the game, but it'd be great if phpWS didn't
try to support every db in the known world.  That way there wouldn't be a
bunch of middle-layer generalized db access protocols to slow everything
down.