|
| Windev AND TERMINAL SERVER |
| Iniciado por guest, 22,oct. 2015 09:16 - 5 respuestas |
| |
| | | |
|
| |
| Publicado el 22,octubre 2015 - 09:16 |
Hey my friends
I know that this topic is not realy for this forum but i take a chance.
What could it be that my software which makes a connection with a MSSQL server is very much faster local on my pc then on a terminal server.
On both computers there is the same virus scanner..
In my opion it should be faster on TS...
I work with V20 but the problem was the same with V19
TIA
Jan |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 08:55 |
Hi,
I'm not an MSSQL expert, but in theory there should be no difference.
Did you test the connection from your own pc to the same MSSQL server as on the TS?
Kind regards,
Joris. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 09:27 |
Hey Joris
Yep i did all is the same
on my pc a report takes 4 seconds on TS 20...:confused:
Still thanks
Jan |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 11:12 |
Hi Jan,
Then i guess the performance problem is related to the TS.
Did you already use the profiler? Maybe this can help you to optimize your code.
http://doc.windev.com/en-US/…
It can be really usefull.
Kind regards,
Joris. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 11:32 |
Hi Jan,
Some time ago (it may be years..) I noticed a difference between using DNS name or the IP-address in the connection to the sql-server. Not sure why, but it helped me. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 13:45 |
1. restart server . if problem persist , set memory limit for sql server as following
Physical RAM MaxServerMem Setting
2GB 1500
4GB 3200
6GB 4800
8GB 6400
12GB 10000
16GB 13500
24GB 21500
32GB 29000
48GB 44000
64GB 60000
72GB 68000
96GB 92000
128GB 124000
2. try disable antivirus and firewall
Hope will help |
| |
| |
| | | |
|
| | | | |
| | |
|