I am trying a "worst-case-scenario" of my databse. I have, so far, come up with some numbers to do the calculations with and perhaps a way of splitting one big table into smaller, yet structured, tables.
(These questions are not limited by hardware, because if the need for speed is there, the revenues are too.) The numbers are: Thought-up number entries in one table: 100 000 000 000 (100 billion) Number of tables: 10 000 (I could perhaps limit the number of entries to a maximum of 9 000 000, but I need to have a hell of a lot of tables.) So here are the questions regarding MySQL: 1) How many tables can one database have? (The absolute maximum) 2) How many entries can one single table have? (The absolute maximum) Any thoughts? // Michelle __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ --------------------------------------------------------------------- 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
