We are using SugarCRM "POST" API call to insert into the modules,but we find out the performance of the Insert operation is too slow.
Is there any other API call we can use to increase the performance of the Insert Operation??
What is your use case? I think the appropriate course of action will depend on precise use case.
You can batch POST requests using Bulk API if you are on a newer version of Sugar 7.x. This would reduce the number of round trip requests.
You could also implement a Sugar Job that reads an upload file of Sugar record data and then processes it in the background. This would reduce overhead and also allow Sugar UI to remain responsive.
If on-premise, you can use a direct database connection to populate module tables. Keep in mind that that this by-passes validation logic so you need to do your own error checking and formatting to ensure that data is inserted properly. This would be fastest method for populating Sugar DB.
Thanks for your quick response.
I'm using v10 API calls and my SugarCRM version is , SugarCRM Version 18.104.22.168 (Build 9)
We are using "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 within the program to insert the records .
Right now the program reads individual records from the .CSV file and passes it into the API call.
Does a user provide a CSV file of their CRM data they want imported?
Why don't you just use Sugar's standard record import feature?
It supports CSVs and would run faster than making many roundtrip calls over the REST API. There is a UI that helps with mapping fields from CSV file into Sugar modules, etc. If you are worried about performance then this is quite likely the fastest option! The main limitation of this Import feature is that it can only move 1,000 records at a time.
However, if you must use some custom Java application for some reason then you could look at Bulk API as a way to batch multiple requests together (say 50 at a time).
Enhancing performance using Sugar 7 Bulk API « Sugar Developer Blog – SugarCRM
Retrieving data ...