"Have I got this wrong?"
Record caching is done, not based on the found set, but based on the layout view. In Form view, records are cached in 25-record chunks. In List or Table view, they're cached as needed to be displayed. So if you have 2,000 records in Form view, the first 25 will be loaded when the user enters that layout. The next 1,975 will be pulled down as the export executes.
Thanks Mike. I was starting to think I got it wrong!
However, I've just connected in remotely and downloaded 4,823 records almost instantly.
I'm thinking it would be quicker to run the query on the server, export the file and have the server email the customer with the data attached! Seems a bit clunky but I'm sure it would be faster than 3 minutes.
Any idea what could cause such a difference between my test on 2.5 times more records and their experience? I guess broadband speed is the most obvious but would it really make that much difference?
Yes, network speed makes a tremendous difference. But network latency makes an even bigger difference. If you're close to the server, and he's farther away, then that alone will account for surprisingly big gaps in performance.
Emailing from the server is a very good alternative in many of these situations, especially if the user doesn't need the data in real time.
Thanks Mike. This is all really useful info.
I've only been using FMS for a few months and I'm learning very fast!