|
| Open() and OpenChild() - WD19 |
| Iniciado por guest, 19,nov. 2014 18:10 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 19,noviembre 2014 - 18:10 |
Hi all,
We are opening a window using OpenChild()and it takes about 2sec to open fully when connected to our cloud VPS. However when we changed connection to localhost, the same command opens the window instantly.
Does anybody have any idea why this happens?
And maybe how to speed it up on the VPS? (Our client thinks 2sec is a bit too slow...)
Thanks
Sarah |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2014 - 18:17 |
| what is on the VPS? Database, application? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2014 - 18:20 |
Hi Paolo,
On the VPS there is an HFSQL with the database.
The application is on the local PCs.
Sarah |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2014 - 18:30 |
what are you running on the init process of these windows/controls?
If they don't run any code in init process they should be as fast as when you use a local database.
Be carefull with remote databases, if you don't limit the amount of data you are reading it will be a problem.
reading the information using hreadfirst/hreadnext, for each and so on should not be use with remote databases. Use as many queries as you can and limit the data you return on the queries to the minimum necessary. |
| |
| |
| | | |
|
| | | | |
| | |
|