All stored procedures and database queries are performed by Nolics and we do not make direct calls to the database. It is not possible to change any of the stored procedures or database queries, because they are controlled by Nolics. There are several changes regarding the performance in Sitefinity 3.7 SP3 ( pages and modules section) and there are small fixes in personalization management that will be available in Sitefinity 3.7 SP4. If you experience some delay on the front end it is possible that your application pool is being recycled or the response from the SQL server is not returned on time due to some package transfer or network delay for connection.
You could try to reduce the database size
which should improve( not significantly ) some parallel operations. You might also find this post useful Tips to optimize backend pefromance
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items