-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
BG --
...and then B.G. Mahesh said...
%
...
%
% Thanks for the quick response. My question may not be very valid..but is
% there a upper limit on the number of records it can handle?
I'll leave this to the experts. I'm almost certain there must be, though
it's probably something like 4 billion or some such.
%
% Hardware wise, I guess if I have atleast 512MB RAM, P4 Intel motherboard I should
% be fine. Isn't it?
There was actually a fair bit of discussion about this (including the
merits of various chips, their capabilities, and their speeds) on this
list a bit back, and it's come up other times before; see the list
archives for details. Basically it comes down to
- figure out where your bottleneck will lie
- RAM? disk I/O? CPU power? floating point math? 'net bandwidth?
- build a system that caters to those bottlenecks
You haven't said how large the records are, how many people will need to
hit it at once, how much math will be involved, and what sort of peak
load it will have to handle (it might sit basically idle for three and a
half weeks and then be slammed generating invoices), but my loose guess
is that you should get a dual-PIII or dual-Athlon box with 512M - 1024M
of RAM and some good SCSI disks you can RAID. It won't be a $500 desktop,
but it probably shouldn't cost you more than $2k to build a quite nice
box (but don't forget to build a second for redundancy, perhaps as a
slave server, since this is business and time is money).
HTH & HAND & Happy Holidays
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)
iD8DBQE9//n/Gb7uCXufRwARAoZFAJ0W6SxXCR8pXD0bT4aS54lqlp1WiACgmMJk
GbUxlpjbdzQ7kkEk8OOHgD4=
=YzNx
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
