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

Hi,

 

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

Outcomes