Query for static data on Database

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.

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.