MySQL Forums
Forum List  »  Newbie

Re: optimising a create table as select
Posted by: Daniel Fisher
Date: May 19, 2014 10:14AM

Just to clarify the best practice is not to incrementally commit

Insert into historical_readings_new select * from historical_readings
Where > 6847513903;

or which I could break this up into separate transactions based on the ID.



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.