slow database

[Jeppe Lund Andersen]

The database is the same
they have the same index's

Jeppe


> -----Original Message-----
> From: Fabian Rami [mailto:fabian.rami at wowcompany.com] 
> Sent: Monday, January 08, 2007 1:58 PM
> To: Jeppe Lund Andersen
> Subject: Re: [UMN_MAPSERVER-USERS] slow database
> 
> Have you build the same Index on your table ?
> 
> Jeppe Lund Andersen a écrit :
> >
> > 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
> >
> 
> 
> 
>