Ignition version 7.6.3.
I have several windows that open very quickly in design mode but painfully slow in clients and in preview mode. Any suggestions?
hard to make a suggestion without seeing anything. post an export of the windows or tell us what is on the windows. do you have scripts that run when the window opens that could be slowing them down?
There is a fairly large table (66Rx 100C) on the page. When I remove this table the page loads very quickly in all circumstances.
My question is why does the page, with the table, load very quickly in design mode but not in preview mode. What is happening in the background in preview mode that is not happening in design mode?
I can’t upload the page to a public forum because it contains a client’s proprietary data.
Have you watched diagnostics when you open the page? It could be throwing errors.
No errors in either preview or design mode…
how long does it take for the query to run when you run it in the query browser?
The query is very fast.
The same query runs when the window is opened in design mode too.
Earlier today I noticed the window opening very slowly when the customer was using the application.
I pulled the script from the navigation button and put it in the script playground. The window opened very quickly and the table showed the right data when running the script from the “playground.”
I then put the project in “preview” mode and pressed the navigation button. The window opened very slowly (more than 10 seconds) and the table showed exactly the same data.
Then I tried the script in the playground with the project in preview mode. Window opened very slowly.
This is very repeatable client or preview results in very slow window opening; design mode, window opens up very quickly.
I removed security from the few objects on which it had been applied. I also removed all bindings to the table (selected row >= 0) as well. It is definitely something with the table though. When I remove the table from the page it opens very quickly. Could it be the 100 columns?
Try reducing the number of columns and see if that makes it run faster – if the problem can be narrowed down like this it can be reproduced and fixed if needed.
The query is very fast.
The same query runs when the window is opened in design mode too.
Earlier today I noticed the window opening very slowly when the customer was using the application.
I pulled the script from the navigation button and put it in the script playground. The window opened very quickly and the table showed the right data when running the script from the "playground."
I then put the project in "preview" mode and pressed the navigation button. The window opened very slowly (more than 10 seconds) and the table showed exactly the same data.
Then I tried the script in the playground with the project in preview mode. Window opened very slowly.
This is very repeatable client or preview results in very slow window opening; design mode, window opens up very quickly.
I removed security from the few objects on which it had been applied. I also removed all bindings to the table (selected row >= 0) as well. It is definitely something with the table though. When I remove the table from the page it opens very quickly. Could it be the 100 columns?[/quote]
very well may be the 100 columns. Im not a database expert by any means but its not often I have seen 20 columns much less 100(never) in a table. I am sure someone can come along and give a better explanation but you may want to look at the way you are storing that data and store it in a narrow format instead of a wide format. It may just be that the table component cant handle that many columns.
Can you post the query that you are running please.
The query is a simple “select columns from view.” Running the same query in the Database Query Browser is very fast.
I assume that this query runs in design mode, because I see data in the table when I open the window.
Most recent test…
I deleted all data in the table via the data viewer. Saved the window. Opened the window in design mode. It opened as close to instantaneously as possible and the correct data is being shown in the table, so the query must have fired, and the data moved from the database to the table on the window.
Same test, but the designer is in Preview mode. The window takes 10 seconds to open.
I reduced the number of columns being selected and the time to load the window did decrease, but not noticeably.
are you doing anything with the table customizer?
I have changed some of the column headings. This is done statically, not with code.
I removed the SQL Query binding, but left the data in the table. Still takes a long time to load.
When you open the window in the client look at the diagnostics window and see how much the memory jumps. The one difference between the designer and client is the amount of default memory they use.
Recently, when testing the canvas paint function, I noticed it causes the client to run very slowly if there is a lot of processing in the event. In this case, unbinding the query from the table should be enough to say that it is something else unassociated with the query causing the problem. This is a pretty good thread for troubleshooting.