Re: server on development machine
Posted by: Peter Brawley
Date: July 01, 2021 10:27AM

Okeh, innodb_buffer_pool_size is now 24G. What are the sizes of your import files?

The united_claims table has a huge column count because it's a normalisation disaster (eg child tables implemented as col1,col2,col3...). Still, import ought not to take hours. The second table, though, doesn't raise such issues. How long does that import take, and how many rows are taken in?

Unfortunately your privacy protection tweaks rendered the import data unusable, so I can't test it.

Options: ReplyQuote


Subject
Written By
Posted
Re: server on development machine
July 01, 2021 10:27AM


Sorry, only registered users may post in this forum.

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.