Hi guys, I’d like to ask for your opinion. Most of my windows that have a table in them lets users have different options to query data, for example I have a table set up that grabs system resources(RAM%,CPU% etc.) every one second so I can be able to go back and look at it if needed.
I let users be able to look at the data every 30 second, every hour and every midnight. When the window opens the time interval is always set to the previous day at midnight to current day at midnight. My data property of the table has a query with 2 if and one else statements that basically check for
if midnight.selected = 1 Run a query if hour.selected = 1 Run a query else "(30 sec)" Run a query
Is that approach good enough or should I maybe have 3 dataset custom properties that each query the data for one of those 3 instances and depending on my selection the corresponding dataset gets displayed in the table?
Just want to see if you all have better ideas to maximize my query timing. I mean the timing is not horrible now, but there is definitely a few seconds lag for queries to appear. anyways thanks in advance for your thoughts.