AnsweredAssumed Answered

SugarCRM query is very slow

Question asked by neeraj.sinha713726 on Aug 13, 2018

Hello There,

 

I have a requirement to fetch around 300000 records from sugarcrm and then process those records, I have set up sugarcrm connector and using query to fetch records but it´s taking around 2 hours to fetch only 50000 records, I have made the changes in query and only fetching 8 fields , but still performance is very slow. I didn´t find anything to use like fetch in batches to optimize performance, please provide me any suggestion to enhance by sugarcrm query performance.

 

Thanks a lot in advance

Outcomes