function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SumitkSumitk 

Create high performance application or optimize existing app

Is there any trailhead or tutorial to create or optimize Salesforce app that can work on large datasets and complex database operations? Currently when we do a lot of SOQL operations the response time gets worse. Please help
ShirishaShirisha (Salesforce Developers) 
Hi Sumit,

Greetings!

If you have SOQL queries which has low performance then you can go for the custom Index which will improve the performance of the queries and return the results as soon as possible.

Even if the custom Index doesn't work then you can go for Skinny Table on the Objects on which you have application to improve the performance.

Reference:https://www.chetu.com/blogs/technical-perspectives/five-ways-to-optimize-your-salesforce-crm.php

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri