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