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
micwamicwa 

API Performance

Does anybody know anything about the API performance?
How is the performance if the query contains for example 25'000 record? Anybody has any experience? Does Salesforce says anything about that issue?

Thanks for your help.
HardhatHardhat
Why don't you try your query with the force.com explorer?  It shows you how long the query takes in ms at the bottom.

The performance of your query is heavily dependent on what it is, whether the criteria include indexed or non-indexed fields, how many OR statements there are, whether there are joins, and so on.  So there's not a single answer to "how will my query perform" except "try it and see."

If you're doing a lot of queries with string criteria, try a SOSL search instead.  For those types of searches SOSL tends to be much faster.