slow database

[Jeppe Lund Andersen]

Hello

iam running mapserver on a windows 2003 server. 
I made an application that uses ODBC connection, when I run it on my local machine that has sql installed it performance fast enough (takes 2 sec to make the map), but if I has a connection to a sql that is on another server the performance is not good (takes 20 sec to make the map).

it is the same database on both machines.

So is it a known fact that when using an external SQL server the performance is slow ?


Med venlig hilsen
 
Jeppe Lund Andersen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070108/62366c29/attachment.html