Skip to main content
J
jesuss0001
August 17, 2023
Question

Query for static data on Database

  • August 17, 2023
  • 10 replies
  • 0 views

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"?

    10 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 17, 2023

    "queryRecordType" or "queryEntity" depends on whether you go with the future and use Records to represent your data.

    mathieud0001
    mathieud0001
    Brainy
    August 17, 2023

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

    J
    jesuss0001Author
    August 21, 2023

    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?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 21, 2023

    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?

    J
    jesuss0001Author
    August 21, 2023

    HI,

    The data are static/parametric tables like cities, countries, ,directions, ...

    Terms & ConditionsAccessibility statement