connection is very slow with server SqlServer
I have made application with c#, WPF, Linq and SqlServer 2008 engine .

the application installed in many PCs and the database remote from the server.

the application installed in 2 department in a Company if the server in one of this department  the connection with server in the other department is slow and to view a datagrid with information it make time to show the window... even the autocomplete box with the name of the client of this company make time to display the names :(

I don't know where's the pb ... I have same bad query and I have fix some of it but there's some table just 

> dg.itemssource =
> connexion.client.select(a=>a);

 and it make time :/

PS: in the begging the application not that slow but after 6 month of work become nasty ... when the table of database is bigger the application get more slow !!!

what I have to do.

sorry to bothering you with all this text .... but I want to explain the pb I have and thank you.
connection is very slow with server SqlServer
===

I have made application with c#, WPF, Linq and SqlServer 2008 engine .

the application installed in many PCs and the database remote from the server.

the application installed in 2 department in a Company if the server in one of this department  the connection with server in the other department is slow and to view a datagrid with information it make time to show the window... even the autocomplete box with the name of the client of this company make time to display the names :(

I don't know where's the pb ... I have same bad query and I have fix some of it but there's some table just 

> dg.itemssource =
> connexion.client.select(a=>a);

 and it make time :/

PS: in the begging the application not that slow but after 6 month of work become nasty ... when the table of database is bigger the application get more slow !!!

what I have to do.

sorry to bothering you with all this text .... but I want to explain the pb I have and thank you.