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