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"?
Discussion posts and replies are publicly visible
Hi, thanks for response
I was researching after seeing this post https://community.appian.com/discussions/f/data/22641/record-vs-cdt-performance-comparison where finally he said query entity is more fast than "queryRecordType".
I did performance tests with "queryRecordType" and "queryEntity"
My first test was to do a simple query to a table with cases in which I retrieve 100 records.
the test with queryRecordType: in this case I have a synchronize records.
the same test with "queryEntity"
Query entity has better performance than query record for simple query
My question: Is better "query entity" than "query record" for static data in database?
Sorry, but I need to repeat my first response. Records are the future, but depending on your specific query and Appian version, you might see faster or slower query times. Appian will make sure that Records become faster over time.
But, I would like to know what you mean with static data. Is this data you need to query in most/many situations? If the volume is small, did you consider to use the textCache plugin?
HI,
The data are static/parametric tables like cities, countries, ,directions, ...
I recommend to go with Records and queryRecordType. This way you can define the whole data model using relationships. This makes many thing so much easier.
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.