# Faster loading perspective page, a table and an xychart with some flex containers, 8.1 **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [June 17, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902 "2022-06-17T17:48:16Z")\ **Posts on this page:** 9\ **Page:** 2
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 20, 2022, 3:33pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/21 "2022-06-20T15:33:45Z")
As I am sure you have deduced, there isn't really a "general" answer. It is dependent on many things. How fast is your query. How good is your connection between the client and the gateway. How good is your connection between the gateway and the DB. What kind of load is the DB under? What kind of load is the Gateway under? How many indexes are in the table you are querrying? Are you performing joins in the query? Are you performing unions? Is the data running through any kind of transform? What is that transform doing? etc.... > [@zacharyw.larson](#): > > Do you have a table with 1000 rows on a page that loads in a second? If so, how did you set it up? No, because in my opinion, displaying 1000 rows of data to a user is useless. Instead, I do things like when a user clicks on a data point, present that row and only that row. ( I haven't done this in perspective just yet, but I will) Or I will have filters which will allow the user to pull the data that they are interested in. I very rarely find my self presenting huge blocks of data to a user, and when I do I take a step back and consider if there is a more user friendly and visual way to communicate what I'm trying to communicate. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 20, 2022, 3:38pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/22 "2022-06-20T15:38:49Z")
I have loaded a 1000 rows in Perspective quickly, it seemed instant, I’m guessing under a second (I didn’t time it). But, to @lrose point, it isn’t wise. I did it to test. An operator being presented with that much data can’t be good. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [June 20, 2022, 3:40pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/23 "2022-06-20T15:40:08Z")
It is not an option to not do for me. It is the requirement of the page to display the last several days of OEE data for several machines. So I need a way to do it efficiently. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 20, 2022, 3:42pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/24 "2022-06-20T15:42:43Z")
How fast is the query itself? ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [June 20, 2022, 3:45pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/25 "2022-06-20T15:45:36Z")
As just that one page, one page, one configuration, I got the query down to less than half a second. Another page, another way, I pull the data from a dataset tag. Both have 7 seconds delay. If someone has setup 1000 rows to show up faster than a second in perspective, I want to copy that technique. I want to find out which of the things LRose mentioned are the cause of the delay. I think maybe I need to make an XY container and just a 1000 row table from a tag to test. I don’t think it is the database connection, because even from the tag, I get the delay. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [June 20, 2022, 5:17pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/26 "2022-06-20T17:17:46Z")
> [@lrose](#): > > No, because in my opinion, displaying 1000 rows of data to a user is useless. I've been asked to display the history of ~30k tags over the last 6 months :X ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 20, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/27 "2022-06-20T18:05:47Z")
> [@zacharyw.larson](#): > > I want to find out which of the things LRose mentioned are the cause of the delay. > I think maybe I need to make an XY container and just a 1000 row table from a tag to test. Just to clarify, I was only showing a myriad of reasons that your performance could be slower than expected, I didn't even come close to listing them all. > [@zacharyw.larson](#): > > If someone has setup 1000 rows to show up faster than a second in perspective, I want to copy that technique. That is the point we've been trying to make. Performance is specific to _your_ task on _your_ system. Sure, we might be able to point you in the direction of best practices or what not, but at the end of the day it will be dependent on _your_ system. As a point of reference, I can query 20K+ rows in less than 0.5 secs on my system, with 12 columns of data and a single index. If it is important that you make this performant, then as suggested, contact support. We can't optimize what you're trying to optimize without seeing it. > [@pascal.fragnoud](#): > > display the history of ~30k tags over the last 6 months :X Hopefully, not for an operator. I can see the downtime reports here, "Down for 5 mins searching for data in table" Sometimes people really don't know what they're asking for. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 20, 2022, 6:43pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/28 "2022-06-20T18:43:05Z")
> [@lrose](#): > > If it is important that you make this performant, then as suggested, contact support. Well, that might be a bit more to ask of support than support is really for. See the [support policy](https://inductiveautomation.com/support/policy/). This is the kind of thing customers are expected to _ **pay** _ IA sales engineering for. Or pay another integrator. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [June 20, 2022, 6:47pm UTC](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902/29 "2022-06-20T18:47:19Z")
Not if it’s a genuine bug, because the OP is on 8.1.0. Could be a quick phone call… “upgrade…” [Previous page](https://forum.inductiveautomation.com/t/faster-loading-perspective-page-a-table-and-an-xychart-with-some-flex-containers-8-1/60902.md?page=1)