At 06:28 AM 3/24/2009, you wrote:
Hello @all.
I`ve got the question how mysql will have to be set up, that it can handle
round about 7.000.000 records most efficiently.
What do you think about the the hard and software requirements in order to
match the best combination?
The data will come from oracle, so it would be interessting to, how I will
have to import the data. Does this work once, or will I have to divide the
data in several parts for import?
Best Greetings,
Frank
Frank,
The fastest way to import data from Oracle would be as a CSV file and
then use Load Data Infile to import the data into MySQL. 7 million records
should load in a couple of minutes. Make sure you confirm the row counts
are equal after you have imported the data.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org