At 10:27 22/01/2004 +1100, you wrote:

> > in database A will be 1, 11, 21, 31, 41, 51, etc
> > in database B will be 2, 12, 22, 32, 42, 52, etc
> > ....
> > in database I will be 9, 19, 29, 39, 49, 59, etc
> >
> > You just set this gap to the number of diferent sites
> > (databases) you will have
> >
> > A simple solution does anyone see any drawbacks ?
> >
>
>One drawback...this will start with one site, but could scale to 100...it'd
>be a shame to put a limit, no matter how high it is.
>
>Another interesting idea, though!
>
>Gosh, I've got notes everywhere, now! :P
>
>N.

Hi Nigel,

Theorically you will have a limit, but if you set the gap to 1,000 you
could have 1000 different sites.

and each table on each site could have roughly 10^16 records (using 64 bit
integers)

if you set the gap to 1,000,000
each table could have roughly 10^13 records

(if I do the math right ;) )

Sure there is a limit, but I think my clients will never reach then...

But you know 640k will be enough for everyone ;-)


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004


[Non-text portions of this message have been removed]