I don't know the answer to this in mysql, but in oracle, while you can have big files, I've seen tables divided at, say, the 1 million record mark. So there could be 5 files for a fast 5 million record "table". This is seamless to the user if there are views. Alas, mysql doesn't have views :-(.
-----Original Message----- From: Craig Vincent [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 6:28 PM To: MySQL Subject: MySQL/InnoDB question I'm not new to MySQL but have only recently familiarized myself with InnoDB. One question I have so far been able to find an answer on is the datafiles. Let's assume I have 5 GB worth of information, this information changes regularly. Performance wise....would I be better off using a single 5GB file, or would there be benefits to using multiple datafiles....say 5 datafiles containing 1GB of information each? Any documentation/links providing additional information in regards to this would be much appreciated. I couldn't find anything at either the MySQL or InnoDB site in regards to this. Sincerely, Craig Vincent --------------------------------------------------------------------- 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