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 wisewould I be better off using a single 5GB
file, or would there be benefits to using multiple datafilessay 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