I am in process of transposing (it is really a re-design and re-write) a VB6 app to a Xojo Web application. I have a few pages done, and I uploaded the application (standalone mode) to my server. A dual Xeon with ample RAM, running Windows Server 64 bits. The app is connected to a MS SQL Server database through ADO.
I find that the application is quite snappy when called from the LAN. However, when I use an external connexion, page rendering is surprisingly slow. I double-checked all the obvious: connexion bottlenecks, etc. I also made sure to avoid things like images in my pages. Still, page rendering is quite slow. Once a page is loaded, data updates happen very fast. It is clearly building the page that takes a long time. Some of my pages contain many controls. The lack of a decent grid (please don’t tell me listbox… I use it. But it is not a grid!) forces me to build my own using labels and text boxes. I limit the number of rows and columns, and use code to scroll data on the grid, rather scrolling the grid with data. My home made grid acts as a window on data, but does not hold all the data. But, as I said, data updates are really snappy. Building the page is what hurts.
I looked, but did not really find best practices for performance optimization. Any good tips will be greatly appreciated.