>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.
Well obviously there's the time it takes the data to get from the server to your m/c, then there's the contention between your user and other users of the network for time (just like the internet slows down when there's a lot of traffic)
>
>A. How can I speed this up?
Write more efficient SQL?
>
>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?
You could put up a Wait Window "Query in progress. Please wait ..." NoWait NoClear before the SQL and
Wait Clear afterwards.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.