-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jim, et al --
...and then JamesD said... % % I've read limits are based on the filesize your OS can handle, % the HDD size, memory, how fast your RISC Yeah, these make sense, but that means that they're not really mysql limits but hardware or OS limits. I suspect that there's some value like 2^32 or 2^64 records as a limit or some such, and the practical answer is that it's the box and not the software that will limit you, but I don't have the internal details. % or CISC processors are...and how the stars are aligned... *grin* % % i think 4 billion records will need some horses pullin... Oh, sure; I definitely agree. That wasn't the question, though. % 8 x 2.4 XEON/2 at least. I've run simple queries on Maybe more than that, depending on how big the records are and how much they're being accessed. But I specifically wasn't talking about HW/OS limitations because he wasn't :-) % 80 million records and it takes minutes with a gig of RAM % and 800 pentium III. each minute in front of a computer is % like dog years... 1 = 7 *grin* Too true... % % % Jim 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) iD8DBQE+AHQLGb7uCXufRwARAlwlAKDLJayKJY4zl+zVxOf0k81D1WZCsACguBtZ 14t/phnq1inNkNtmAQrDioU= =LtVh -----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
