MySQL Forums
Forum List  »  Newbie

Re: Faster transfer of 2 billion records between two database tables
Posted by: Peter Brawley
Date: April 21, 2018 12:37AM

> I couldn't run delete query since I creation of duplicate table
> is still going on.

In such circumstances make a test table of a 100k rows or so, then benchmark various queries.

> I ma looking for a software that would complete the complete query in few hours.

Forget it. No "software" will beat the performance of a well-tuned sql query.

> Can you please elaborate more on what you mean by dupe-skip logic?

Your delete...where... query

> Also, do you think converting original table to csv format,
> process text on csv file, and convert csv file to a new table
> be a good idea?

csv tables aren't designed for optimisation.

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.