Information générale
Catégorie:
Applications Internet
Titre:
I need to move my app from network server to internet access
Versions des environnements
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?
Mike
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement