This is going to be a fairly vague question (sorry) but I’m curious if anyone could give me some general strategies for building clients using “advanced” features and a lot of SQL queries that run more efficiently. I have been working on building a client that works as a scheduling tool- currently the screen has about 50 power tables on it. The power tables are using almost all of built in extension functions (row dragging, cell format, header format, popup trigger etc). On a fast computer this works fine, but it drags too much CPU on slower machines the way that I have it built right now and is kind of cumbersome to use.
Is there a good way I can figure out where the slow down is coming from specifically? Ie is it scripting, SQL queries, property bindings, power table extension functions, etc?
I haven’t adjusted the database connection settings from default- are there particular DB connection settings that might help with performance from the client side? As far as I can tell, the DB is not dragging anything down (looking at live values from Gateway DB config I am not able to see any active queries and average duration stays at 0.0s.)
Also, similar question: is it possible to have the user change the SQL poll rate from Absolute(5seconds) to Off on the SQL bindings? I’m imagining putting in a custom property and then linking to the poll rate on the tables, but I’m not sure how to access this SQL poll rate property. This would allow slower machines to turn off “auto refresh” on the tables, which might speed it up a little bit?