Craig,
I think that what you suggest is against traditional database design.
There are databases that support hundred of transactions per
seconds and contains millions of records withouth any problem. All
you need to do is choose the good infrasctructure and have a
proper design. This is feasible with NT and MSSQL, but many
believe that Unix offers a better infrastructure.
The e-gold economy currently generates less than 1 transaction
per 10 seconds on average... In other word, it is a very small
application. Even at peak periods, I doubt we reach one transaction
per 5 seconds. In other words, there should be no problems.
On 30 Aug 2000, at 12:04, Craig Haynie wrote:
> Correct me if I'm wrong, but the long-term solution to exponential growth in
> the e-gold network is NOT necessarily moving everything to UNIX; rather
> designing the database so that it resides on multiple servers, serving
> multiple tasks and multiple users.
>
> For starters: Split the e-gold user-base into 4 parts:
>
> Group 1: Accounts 0 - 125000
> Group 2: Accounts 125001 - 150000
> Group 3: Accounts 150001 - 175000
> Group 4: Accounts 175001 - 200000
> [etc]
>
> Then split the e-gold database, with the User Tables and the Transaction
> History tables into 4 databases, each containing all the information for
> each of the groups defined above, and ONLY those groups.
...
---
You are currently subscribed to e-gold-list as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
