Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have two similar schema DBs which I need to merge. I was thinking about the performance issues which I need to keep in mind while creating the script. These are the ones which I can think of.

  1. Should not Select more than a pre-specified data each time to insert in the table(use LIMITS) and the amount of data depends on the memory(RAM) we have.
  2. Don't take locks on tables while selecting the data.

Can anyone please give me more points which needs to be kept in mind while creating the script?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.