my sugar instance is taking around 15 seconds to authenticate user both from web and rest API, what is the problem?
If you're on a self hosted instance, increase the logging level by adding something like the following into your `config_override.php` file:
$sugar_config['logger']['level'] = 'error';
Then authenticate again, and look for any obvious errors in your sugarcrm.log file (things like HTTP Timeouts connecting to external services, etc).
If nothing obvious jumps out, trying changing the log level from error to info and look for things like SQL query response times, which should give you lines in your log file like:
Query:SELECT id FROM ...Query Execution Time:0.001387123151
And if still nothing jumps out at you, check the timestamps between events. For example if you see something like:
Jul 2 19:55:44 19f293492 sugarcrm: Entered operation status: saving_relatedJul 2 19:55:54 19f293492 sugarcrm: Left operationstatus: saving_related
Then you might want to figure out why that operation ate up 10 seconds of time.
Also make sure your instance has some sort of cache mechanism available/configured, i.e. Redis, Memcached, etc. to prevent excessive calls to the database, and make sure you're instance is not running in developerMode (check config.php and config_override.php as that will cause Sugar to ignore any pre-compiled files on disk and recompile on every operation.
Lastly, if you're just doing development on a local machine and this isn't a production instance (you didn't specify), and you're running in some sort of Docker container or virtual machine on Windows or OS X, then yes unfortunately it's going to be slow depending on your setup.
Thank you for replying. Its not a self hosted instance, it is instancename.sugarondemand.com. I am fairly new to sugar crm, the instance was logging in fast before it was moved to a new version by sugarcrm team. Also as you mentioned, there are some SQL statement errors appearing in the system logs, how do I find out the source of that error?
If your instance is hosted by SugarCRM you would most likely want to open a Support Case then so they help to diagnose the issue.
Retrieving data ...