Query for static data on Database

Question

Hi all, 
 I wanted to know about the best option for a query in static data on database. 
 
 which would be the most optimal performance: "queryRecordType" or "queryEntity"?

Mathieu Drouin · Answer

I would always prioritize queryRecordType (with data sync) over queryEntity unless you have specific requirements

Mathieu Drouin · Answer

Same answer as before. 
 Technically speaking if you create a synced Record for your reference data values, you can create relations from your Record to your reference data Record which allow you to get all the information in one single query instead of multiple queries (1 for the Record and 1 for the Reference Data) and that will be faster. 
 Furthermore, I'm pretty sure that if you run that query multiple times, you will get similar response times in the end.

Query for static data on Database

Top Replies