SugarCRM REST API with field parameter impact on Sugar performance

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

  • Hi,

    Answer to your question, Yes field parameter's impact on performance.

    1) Fetch only required field instead  fetching all fields associated with contact modules. (Optimization is very important)

    2) Add deleted condition while fetching record it is important not only in Sugar API call but also in custom SugarQuery.

    3) One suggestion, Check is there any heavy code in process record logic hook. if yes, It will be impact on performance.

    If we are not giving such condition that means we are giving load on application. I would recommend use filter conditions.

    Best Regards,

    Sagar