Performance of Insert Operation is too slow

Hi Anush,

which version of SugarCRM are you using?

Greets,

Mark

Hi Anush,

which version of SugarCRM are you using?

Greets,

Mark

Hi Mark,

Thanks for your quick response.

I'm using v10 API calls and my SugarCRM version is , SugarCRM  Version 7.6.2.1 (Build 9)

Importing any meaningful amount of data into SugarOnDemand has been painful to say the least.  Both SOAP and REST APIs are SLOW.  I'm experiencing 3 seconds per record in the SOAP API and even longer in REST API.  The import file feature may be faster, but you have to subdivide your import file, so now you're stuck managing that dog of a process. 

This is an issue that needs to be addressed by SugarCRM.  Without an efficient way to update your database, it will get stale and inaccurate.  If anyone finds a better solution, I'd like to hear about it.

Hi Anush,

If you are inserting data using API make sure is there any big logic hook functions calling or maybe any recursive calling.  I tried to use rest API for insert record and its taking only 902 ms insert single record.  so you need to check logic hooks.

Regards,

Sagar