• State Not Answered
  • Replies 28 replies
  • Subscribers 8 subscribers
  • Views 20379 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Questions about Querying Data from an RDBMS

harshav

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...

OriginalPostID-196692

OriginalPostID-196692

  Discussion posts and replies are publicly visible

Parents
  • 0
    @philb,@tim,@narasimhaadityac,@sparshs Thank you so much for responding on this but still in the confusion. As suggested by philb in the example it says there is not much difference making with limited data but my report is fetching more than 100K of data so not sure how this would work at that time, also let me explain you how am I querying the data.
    1.This is basically written for Report.
    2.Rule contains a choose in load function ,based on some selection each rule is called in choose function lets say rule!xyz(parameters,paginginfor(1,25)). now when this is called my page is taking so much time to load. So in this case could I go for query entity or is there any way I can make my page load. Last but not the least, from the comments from philb, "No doubt Appian will be able to provide some more detailed analysis" could someone from Appian give us more detailed Analysis it would be great ..... Once again Thank you so much guys :) !!!
Reply
  • 0
    @philb,@tim,@narasimhaadityac,@sparshs Thank you so much for responding on this but still in the confusion. As suggested by philb in the example it says there is not much difference making with limited data but my report is fetching more than 100K of data so not sure how this would work at that time, also let me explain you how am I querying the data.
    1.This is basically written for Report.
    2.Rule contains a choose in load function ,based on some selection each rule is called in choose function lets say rule!xyz(parameters,paginginfor(1,25)). now when this is called my page is taking so much time to load. So in this case could I go for query entity or is there any way I can make my page load. Last but not the least, from the comments from philb, "No doubt Appian will be able to provide some more detailed analysis" could someone from Appian give us more detailed Analysis it would be great ..... Once again Thank you so much guys :) !!!
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.