MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Loading data into mysql tables taking insanely long time
Posted by: Peter Brawley
Date: February 20, 2018 07:15PM

Several days suggests the mem demands have outrun what's available, causing swapping. You'll need to tune the db and the app.

Load Data from a .csv file will be much quicker, so preprocessing the xml file to csv will improve performance.

If it's still slow with Load Data, the tables involved may need optimisation.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Loading data into mysql tables taking insanely long time
PURNACHANDRA IRUKULAPATI
February 20, 2018 03:51PM
Re: Loading data into mysql tables taking insanely long time
Peter Brawley
February 20, 2018 07:15PM


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.