Running Version 7.1.2 on Debian 6/32. Have about 10,000 contacts in the database and growing daily. Queries are taking about 2 minutes now. Is there a way to speed it up? I have already allocated 100% of the CPU on the server to the OS.
Management is going to start questioning things soon I fear.
10k records or even more should not be the problem. There are several ways you can improve the speed. Optimize the server to handle the mysql and php processes on different processors. Optimize the queries, Check for slow queries logs and see if you can improve. Make sure the developer mode is turned off and log level is set to fatal.
add the following in your config_override.php
$sugar_config['disable_count_query'] = true;
$sugar_config['save_query'] = 'populate_only';
$sugar_config['verify_client_ip'] = false;
$sugar_config['hide_subpanels'] = true;
$sugar_config['hide_subpanels_on_login'] = true;