Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Adam M. <ad...@tu...>]

I'm with the single table idea for all sequence numbers.

This way we can have one select on init that loads all sequence numbers
into a session array.  Then on inserts we only have to update the
core_sequencer table instead of select AND update it (thinking of reducing
database accesses).

Also, with all the sequence numbers in the core table, we can get rid of
the current _seq tables getting our table total back down to around 23 :)
(organizational +).

Another plus? A quick re-write of the sqlmaxid function can simply return
the id in the sessioned sequence array (less database action=good...there
may be more functions that can take advantage).

We can continue to rely on the pear package, we just need to try and get
the best of all worlds.

Adam

---------------------------------
Adam Morton
Developer - Web Technology Group
Appalachian State University
http://phpwebsite.appstate.edu