Performance of Insert Operation is too slow

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)

Hi Anush,

have a look at the PUT api call:

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.5/API/Web_Services/Examples/v10/module…

Cannot say if this helps for your specific case. You also might have a general performance problem. Do you host yourself or wiht Sugar On-Demand?

Greets,

Mark

Hi Mark,

We are using "PUT" API call to update the records and "POST" API call to insert the record.

We are hosting it in SugarOn-Demand.

Scenario is :

I have written a JAVA program which will read data from .CSV file and writes into the SugarCRM .We are using "POST" API call to insert the records within the program.

Hi Anush,

you might also try to directly import your CSV content directly to SugarCRM:

http://support.sugarcrm.com/Documentation/Sugar_Versions/7.6/Pro/Application_Guide/Import/

This is a lot faster than through the API when you are dealing with big sets of data. What is the usage scenario here? Are you automating the CSV import or is this a manual process?

Greets,

Mark

Hi Mark,

Not only from CSV,from any other sources(like other CRM systems),I want to load data to SugarCRM.

It should be a complete automation process,so i wanted to use API call rather than using CSV import or any other manual process.

Hi Mark,

Not only from CSV,from any other sources(like other CRM systems),I want to load data to SugarCRM.

It should be a complete automation process,so i wanted to use API call rather than using CSV import or any other manual process.