Hi all,

I want to add huge amount of data to the mysql database in chunks.
Lets call it as data1, data2 , data3. Now there are 2 solutions
to the problem:
1. Create the different table for each of data1, data2, data3 etc.
2. Create a single table and add different rows into the table,
   each for data1, data2, data3 etc.

Now I want to know which is the best option, performance wise?

In brief, is operation of creating a new table very costly in
comparision to inserting the row into the table?

Your answers will be of great help.

Thanking you in adnvance.



_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.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

Reply via email to