[Vtigercrm-developers] migration of large database...

[Alan Lord]

On 18/11/14 17:15, Alan Lord wrote:
> Please can you optimise this routine a bit better? I suggested one
> method during the testing of these migration scripts that used SQL joins
> which took the time taken down from ~10hours to around 2 minutes!

In case you forgot, the suggested method (not perfect by any means but a 
good starting point) is here:

http://paste.ubuntu.com/9075107/

The above uses one query per entity module... Instead of one query, and 
a bunch of php pre-processing, for *every* single row in the crmentity 
table.