MySQL Forums
Forum List  »  Performance

insert or load ? best practices and performance
Posted by: Gabriel Madeira
Date: September 16, 2010 01:19PM

Hi every one. I would like to know the best practice for the problem I have:

I have a table that everyday has to be fully updated. I have a txt file with all rows to be imported. I would like to know somethings:

1 - before loading the txt file is better drop the table and create it again or a simple delete * from table will resolve ?
2 - to insert the rows into the table should I use the insert clause or use the command line to load the file ?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.