Hey, Chris.



I think I narrowed this down. You can pass this information on to support.



I use query mode very heavily in the app. I first figured out the performance problem happens when moving a datawindow into query mode. After some more debugging, I was able to isolate a particular datawindow that was especially bad. As a test, I created a window, added a datawindow control and assigned the datawindow object. In the Open event, I put the datawindow into query mode. The window took 8-10 seconds to open.



Two important things. I use themes and I use a lot of expressions in datawindows. The expressions are usually for protecting fields. If the datawindow is in query mode, I will enable column objects. If the datawindow is not in query mode, I will enable/disable the column objects based on other criteria. I also change the background color of the columns so they appear disabled. I did not see a way to apply a theme color dynamically in a datawindow. My work-around was to put computed columns in the header of the datawindow that called a function which returned the appropriate color. The functions just returned color values that were loaded at the start of the app. For example, I had a computed column called disabledColor. The expression was f_DisabledColor() which returned the color I wanted based on theme. The background expression would reference the value of the computed column (IF(DESCRIBE("datawindow.querymode"='yes'), enabledColor, disabledColor)).



Long story short, I put constants in the computed columns and everything worked perfectly. My guess is the computed columns are evaluated every time they are referenced in an expression. In query mode, this might be times 20 for each row. My work-around was probably not the best, but there still is a very significant difference between the behavior of PowerClient and PBDs.



I hope this helps. I can probably put together a quick app for support to play with if you want.



Thank you for all you do,

Joe

Hi Joe ... Hmmm ...

QueryMode should be lightening fast. If not, that would be a bug.

Themes does have more overhead though at Window/Control "paint" time.

Hi Joe, Really appreciate you sharing your analysis and the solution. if you don't mind, we would love to have a quick app. Please open a support ticket: https://www.appeon.com/standardsupport/newbug Thank you very much for your help to make PowerBuilder great!!!