General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Hi,
When I run the same SQL statement locally on a local copy of the exact same tables my SQL stement executes within 3-4 seconds. Running the same query statement on the tables located on a file server where the "live" tables and databse reside completion of the statement takes 10-13 seconds and sometimes longer.
A. How can I speed this up?
B. Also as the user is waiting for the SQL to complete, is there a way to display some sort of "working/querying" bar so the user will know that the computer is working?
Thanks in advance!
John
Next
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