Re: insert or load ? best practices and performance
Posted by:
Rick James
Date: September 17, 2010 06:37PM
If practical, do this:
DROP TABLE IF EXISTS old; -- comes into effect after first day
CREATE TABLE new LIKE real; -- easy to create identical schema
LOAD DATA INFILE ... INTO new; -- very fast
RENAME TABLE real TO old, new TO real; -- zero downtime
Caveat: If you have FOREIGN KEYS, there may be issues.
Subject
Views
Written By
Posted
3579
September 16, 2010 01:19PM
1070
September 17, 2010 09:27AM
989
September 21, 2010 11:16AM
970
September 21, 2010 03:29PM
Re: insert or load ? best practices and performance
1009
September 17, 2010 06:37PM
955
September 20, 2010 06:44AM
898
September 20, 2010 10:43AM
1030
September 20, 2010 12:49PM
1089
September 20, 2010 06:28PM
969
September 21, 2010 06:52AM
941
September 21, 2010 11:07AM
942
September 22, 2010 12:14PM
1019
September 22, 2010 07:20PM
1044
September 23, 2010 08:17AM
882
September 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.