Re: one global sequence vs seperate sequences

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 23 Mar 2005 09:42:41 -0800
Message-ID: <1111599761.962906.299400@f14g2000cwb.googlegroups.com>

yes, the key question is really:
Why do you need pseudoKeys at all?

As Daniel said which sequence produces the pseudo key is irrelevant. The one reason I can think of to have separate keys is to save a few digits. eg, the sequence used to key companies might be set to wrap values at 5digits, 00000-99999, while the user account sequence might be set for 9 digits. Using one sequence means you want it to wrap at the highest possible level (because a lot will be "lost" due to caching).

Ed Received on Wed Mar 23 2005 - 11:42:41 CST