RE: [phplib] nextid and performance From: layne <email protected>
Date: 10/03/00

> I guess the point of nextid is portability.

snip

> Is this a well known issue/preference debate in database
> design that I am just not aware of?

IMHO, auto-incrementing columns work fine for most applications. However
there are a few specific cases when it is handy.

Example: I have a content management system where several entities will edit
content before it is published on the site. I maintain two nearly-identical
databases - one for editing and one for publishing - to ensure that
references to related data are maintained when moving data from edit to
publish I simply cannot rely on an auto-incrementing column.

I only use this feature in less than 5% of my scripts, but its very nice to
have around when I do want it.

Layne Weathers
Lead Programmer
Ifworld, Inc.

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>