Control Web service effect on CRM performance

By | January 4, 2014

Web service API in Sage CRM enables developers to manipulate CRM records remotely with SOAP (Simple Object Access Protocol) over HTTP using XML (Extensible Markup Language). It is possible to access a CRM server or a hosted system from a specified client machine (typically another server) in order to read, create, update, or delete records for each exposed entity, for example, Companies, People, Opportunities, Cases, Quotes and Orders.
GUMU : Web Access for your Sage 500 ERP data with GUMU Sage CRM

When CRM is installed, the web service WSDL can be consumed through below URL.
http://<Server Name/IP>/<CRM Instance Name>/eware.dll/Webservice/Webservice.wsdl
Now as the web service API’s are available, your clients may come up with requirement to utilize them with their third party applications to read and write data in CRM. However as you know increased read, write operations may increase load on CRM database and degrade the performance. Also parallel read write operations may result in locking issues. So it’s not always preferable to allow web services query huge data altogether. We can control these using couple settings available under Administration | System | Web Services.

1

 Using this setting we can control size of data returned by web service. We can set this value in order to return only specific number of records through. For example if we set this count to 100, application querying the records from CRM through web service can query only 100 records at a time.
The New Stuff : SMTP details for Custom Emails from COM API
2. Maximum size of request
Using this setting we can control size of data/request sent to web service. If we set this parameter to 1000000, only 1000000 characters can be sent in request stream. This helps if you are expecting specified length of requests from third party application.
Also Read:
1) Enabling entities for web service access
2) Web Service Configurations in Sage CRM
3) Auto login using SageCRM WebServices
4) Enable external access for CRM entities from within CRM
5) 3 Easy Steps to Add Sage CRM Custom Entity in Advanced Find