> > Your system will fail under heavy multi-user load, count on it.
>
> No it won't. Sorry but I've done the above and tested heavily...

You have to give up one or the other. You cannot have sequentiality and
contiguousness in a multi-user environment without going to a second phase,
which means you cannot do it with a primary key at the same time. If you
don't accept this statement, then we simply need to agree to disagree. I
don't think I can make it any more clear that I have.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com