Re: insert or load ? best practices and performance
Posted by:
Rick James
Date: September 21, 2010 03:29PM
Sure, the time will be the same.
I work in a 24/7 environment -- no downtime, no locking tables for more than seconds, etc.
I assume you are on a live system, where you don't want any down time, but you you can avoid writing to the table during the conversion. My approach keeps the old table alive and readable until the RENAME; the RENAME takes zero time; then the new table is live.
If you don't care about staying live, then the neither approach is 'better'.
Also, my approach keeps the old table around (until you DROP it). If the LOAD screws up, you can play RENAME games to get it back.
Subject
Views
Written By
Posted
3923
September 16, 2010 01:19PM
1194
September 17, 2010 09:27AM
1092
September 21, 2010 11:16AM
Re: insert or load ? best practices and performance
1079
September 21, 2010 03:29PM
1128
September 17, 2010 06:37PM
1059
September 20, 2010 06:44AM
1011
September 20, 2010 10:43AM
1148
September 20, 2010 12:49PM
1212
September 20, 2010 06:28PM
1098
September 21, 2010 06:52AM
1036
September 21, 2010 11:07AM
1047
September 22, 2010 12:14PM
1139
September 22, 2010 07:20PM
1160
September 23, 2010 08:17AM
998
September 23, 2010 09:27PM