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.
- 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.
- 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?