>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?
>

1 - Use citrix or terminal services and run the entire app remotely.

2 - use sql server so the database server sends only data back to the workstation.

3 - create some kind of vfp database server that sends only data back to the workstation.

4 - be more rigorous about Rushmore and using indexes, but then you have to understand that DSL is no where near as fast as a LAN. VFP extracts more DBF and CDX data than might be acceptable for DSL.