AnsweredAssumed Answered

SugarCRM REST API with field parameter impact on Sugar performance

Question asked by Vaishali Bhalerao on Feb 8, 2018
Latest reply on Feb 11, 2018 by Sagar Patil



I am using REST API to interact with SugarCRM 7.9.  Our web service call takes about 20 seconds for each set of 20 contact-records to fetch and at each call, it has frozen the Sugar’s contact table and has impacted the whole users.The issue is that we don't set the parameter fields in the call to the API Filter to limit the fields returned by the call.

The Query we are using is: GET /rest/v10/Contacts?filter[0][date_modified][$gte]=1999/01/18%2013:47:51&offset=9780&order_by=date_modified:ASC



While we specify the field parameter then its work without any performance issue. Query for that is :

.Example:: GET /rest/v10/Contacts?filter[0][date_modified][$gte]=2018/01/18%2008:41:38&filter[0][deleted]=1&offset=0&fields=id,date_modified,modified_user_id&deleted=true


anyone know does specify field parameter really impact on Performance of SugarCRM