MySQL Forums :: Performance :: insert or load ? best practices and performance


Advanced Search

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


Subject Views Written By Posted
insert or load ? best practices and performance 2759 Gabriel Madeira 09/16/2010 01:19PM
Re: insert or load ? best practices and performance 821 DBA Lead 09/17/2010 09:27AM
Re: insert or load ? best practices and performance 689 Gabriel Madeira 09/21/2010 11:16AM
Re: insert or load ? best practices and performance 689 Rick James 09/21/2010 03:29PM
Re: insert or load ? best practices and performance 734 Rick James 09/17/2010 06:37PM
Re: insert or load ? best practices and performance 714 Gabriel Madeira 09/20/2010 06:44AM
Re: insert or load ? best practices and performance 665 Rick James 09/20/2010 10:43AM
Re: insert or load ? best practices and performance 745 Gabriel Madeira 09/20/2010 12:49PM
Re: insert or load ? best practices and performance 774 Rick James 09/20/2010 06:28PM
Re: insert or load ? best practices and performance 678 J Wolf 09/21/2010 06:52AM
Re: insert or load ? best practices and performance 666 Gabriel Madeira 09/21/2010 11:07AM
Re: insert or load ? best practices and performance 692 Gabriel Madeira 09/22/2010 12:14PM
Re: insert or load ? best practices and performance 631 Rick James 09/22/2010 07:20PM
Re: insert or load ? best practices and performance 762 Gabriel Madeira 09/23/2010 08:17AM
Re: insert or load ? best practices and performance 636 Rick James 09/23/2010 09:27PM


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.