Hi all,
Our SmartClient solution is working fine when accessed within the network. However, when accessing it over the Internet, the performance is terrible (loading a simple form which displays 5 records takes 30+ seconds).
The Internet connection of the application server is T1 (1.5 MB upload and download speed), the client connections which we have tested with were ADSL and cable connections with 4+MB download 0.4+ MB upload with a reasonable latency of less than 80ms - in other words, very decent connections on both sides. At this point the application server is not using SSL but is behind a proxy server.
What could be causing such poor performance? The database is not an issue - all query times are minimal and there are not that many database hits. The tests are done with just 1 or 2 concurrent test user sessions and there were no locks. Is there any way to determine where the bottleneck is or what the major issues are? Profiling the application in Servoy Developer does not reveal anything abnormal and the application works just fine.
Any hints or clues on what we should look at next will be more than welcome. Any suggestions for available tools or techniques for troubleshooting "live" Servoy deployed solutions will be greatly appreciated.
Thanks in advance for your help.
Rossen