On Thu, 14 Sep 2000, Edward Huang wrote:
> I'm not worrying about the connections. The connections I want is very
> small (10~15), so there should be no problem. Only problem for our database
> is large volume. The largest two tables could go over 20GB. It's pretty
> hard to loadtest this kind of hurge database (take a while to create one
> database with this size).
Out of curiosity how long would it take? Assuming we have a small
app/script which is just sitting there doing INSERT INTO's, allowing it to
take as much CPU time as it needs?
I'm thinking even if it took a week to max out the db and fell over at say
19.5gb, it'd be better to know NOW before you have committed clients and
live systems to try and solve the problem, I remember awhile ago reading
about some EFTPOS/ATM system that was never load tested properly, they
went live, then blam - people actually used the system more than they
expected and it fell over. I'd assume the cost of repair down the line
would be alot higher than the cost at the start... plus you could take a
holiday whilst the db's being populated :)
--
"We don't guarantee anything except that it will take up disk space..."
Apache 2.0alpha5 Disclaimer
Now Playing: <no audio cd present>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
