Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Internet applications
Environment versions
Network:
Windows 2003 Server
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only