Questions about Querying Data from an RDBMS

harshav over 8 years ago

with Reference to this below URL,
forum.appian.com/.../Querying_Data_From_an_RDBMS.html
There are some doubts out of my interest.
Lets consider a scenario, like we have a view which is having 100k of data and it is trying to fetch the data with pagination with 25 records per page. we are using Query rules and we are in version 7.4
Knowing that pagination is given it will load only 25 records per page but our doubt is since pagination is used in the expression rule of displaying the data in grid,
1.Is Query Rule fetching all the records and showing 25 per page or is it hitting the db for the next 25 records,
2.Is this the same way how Query Entity works or is it different.
3.Knowing that the maximum limit of data for Query rule is 1 MB, is it the same for Query Entity or does this differ.
4.How does the performance of Query rule and Query Entity differ if the working of both are same.
Please Sugges...

Discussion posts and replies are publicly visible

Parents

0 PhilB
A Score Level 1
over 8 years ago

I would suggest you test this with a sample table; it's not too much effort to add a table with 100k+ entries and a data store entity - you could then run both query entity and query rules against the table and see how it performs. One thing I would say is if you're actually pulling in 100,000 records, then you're very likely to hit the 1Mb query limit regardless of method.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 8 years ago

I would suggest you test this with a sample table; it's not too much effort to add a table with 100k+ entries and a data store entity - you could then run both query entity and query rules against the table and see how it performs. One thing I would say is if you're actually pulling in 100,000 records, then you're very likely to hit the 1Mb query limit regardless of method.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data