On Saturday 31 March 2007 08:27, Paul McNett wrote: > Carl Karsten wrote: > > If it is an option, use client side GUIDs for your keys. life is so much > > better. the only regret I have is having to not care about people who > > have to use all the other kinds of keys. well, I care, but can't justify > > spending time on addressing the problem. > > I agree wholeheartedly. Client-side UUID's are definitely the ticket, > although they do take more bits per field than ints. I'm particularly > wasteful as I don't bother compressing the 40-byte string returned from > dabo.lib.getRandomUUID().
I'm using Postgres and the data type "serial" is built-in. It's fast and the number is huge. John Fabiani
©2007 johnf |