I have an application that runs locally. There are paths etc built in to locate the data which is stored on a server.

I now need to access data in branches. I created a drive mapping to the database location on the branches server. Let's say K:

The application when run, latches onto the data in K:

My problem is speed. When running locally, i.e. the server is not across the internet, queries take seconds to run. The same report takes minutes! to run across the internet.

The internet connection is DSL..

I have no indexes on deleted on any of my tables. The data for the report is selected via an sql select statement. i.e. date

The application, runs on the users hard drive with a path to the server. It loads quickly.

What should I do to speed up queries?

Mike