Gustav Brock
Gustav at cactus.dk
Fri Mar 4 08:10:08 CST 2011
Hi Shamil et al This is where GUIDs come in. /gustav >>> shamil at smsconsulting.spb.ru 04-03-2011 11:05 >>> Hi Stuart -- <<< I've never had a problem with an autonumber >>> "There is no free cheese in this world" you know :) - replication could create subtle collision issues when autonumbers used - and that would be another kind of collision from the one which could "arise its ugly head" when natural PKs are used; - memory overhead is another issue as Jim noted ("consistent data modelers" do neglect it); - ... Isn't it time now to recapitulate constructively this discussion and to list pedantically pros and cons of every approach? Anybody? Thank you. -- Shamil