function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Julie Curry 19Julie Curry 19 

SOQLXplorer repeatedly timing out

I'm trying to run some queries with SOQLXplorer and I'm having issues with it repeatedly timing out. I'm wondering if there is something I can do to prevent this. 
To give some context, the repeated timeouts are for objects with a total of 10m+ records. I've tried the below without luck so I'm wondering if anyone else has other suggestions. Thanks!
-running the query during non-peak/work hours
-narrowing the criteria to small windows such as 1 day
VinayVinay (Salesforce Developers) 
Hi Julie,

Can you try with Developer console and do you see time out issues? 

You might need to index fields that are part of SOQL query.

Thanks,
Vinay Kumar
Julie Curry 19Julie Curry 19
@vinay thank you so much for your help. I just tried the dev console and I receive a message there was a communication failure:/
 
VinayVinay (Salesforce Developers) 
You need to optimize your query.

Review below links
https://help.salesforce.com/articleView?id=000325257&language=en_US&type=1&mode=1
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_VLSQ.htm

Query Plan.
https://help.salesforce.com/articleView?id=000334796&type=1&mode=1

Thanks,
Vinay Kumar