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[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[date_modified][$gte]=2018/01/18%2008:41:38&filter[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