Forum Discussion
EvanMartinez
5 years agoModerator
Hi Davy,
Just to jump in on what Mark was saying that the way reports render and decide how many rows to show has to do with data density. When opening a report QB runs an assessment based on the amount of data and will show the report that is optimal for performance. What that means is sometimes you can get a large number of rows but as the amount of data increases the rows will decrease. One great way to do this is to look at the number of columns and remove unnecessary, the other is to look at the amount of data in your columns. For example if your report is full of fields that have paragraphs of information in them that can cause your report to have less rows. Since it has to do with a data calculation there isn't a guide for that as different fields will have different calculations and amount of data in them so it can take a little bit of experimentation but that is in the spirit of making reports accessible without taking forever to load. I hope that information is helpful.
------------------------------
Evan Martinez
Community Marketing Manager
Quickbase
------------------------------
Just to jump in on what Mark was saying that the way reports render and decide how many rows to show has to do with data density. When opening a report QB runs an assessment based on the amount of data and will show the report that is optimal for performance. What that means is sometimes you can get a large number of rows but as the amount of data increases the rows will decrease. One great way to do this is to look at the number of columns and remove unnecessary, the other is to look at the amount of data in your columns. For example if your report is full of fields that have paragraphs of information in them that can cause your report to have less rows. Since it has to do with a data calculation there isn't a guide for that as different fields will have different calculations and amount of data in them so it can take a little bit of experimentation but that is in the spirit of making reports accessible without taking forever to load. I hope that information is helpful.
------------------------------
Evan Martinez
Community Marketing Manager
Quickbase
------------------------------
DavyOu1
5 years agoQrew Trainee
Hi Evan,
That definitely makes sense! I also believe quickbase does this for full optimization in consideration of loading time, UI/UX etc.
Thanks for the explanation again!
------------------------------
Thank you for your help!
Davy Ou, Quantitative Financial analyst
Certified QuickBase Developer, Lifetime learner
https://www.linkedin.com/in/davyou/
------------------------------
That definitely makes sense! I also believe quickbase does this for full optimization in consideration of loading time, UI/UX etc.
Thanks for the explanation again!
------------------------------
Thank you for your help!
Davy Ou, Quantitative Financial analyst
Certified QuickBase Developer, Lifetime learner
https://www.linkedin.com/in/davyou/
------------------------------