Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Performance issues in a Win2003 server environment.
Versions des environnements
Network:
Windows 2003 Server
Hi;
I have a small network of WinXp machines running on a Win2003 server. There is no SQL server. My application resides on a share on the server, and we run it from a shortcut on the desktop. The database and the tables reside on the same share as the application.
Queries take a very long time to complete when running through the network. A query that takes under a second to complete locally, would take 10 seconds to complete through the network.
My question (Finally): Is there a trick to solving this problem without going client-server? I would like to continue using SQL commands, but I may need to create cursor and then seek and populate the cursor manually (This is very fast even through the network).
Thank you all,
Alen.
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