Thomas,

I'm uploading the files and will send you an e-mail separately on how to get them.

If anyone else is masochistic enough to want to see what the problem is, let me know and I'll e-mail you privately as well.

I really appreciate everyone's helpful suggestions.

I haven't cleared enough room on my notebook yet to defrag it, but again, since I'm getting similar results on disparate hardware configurations (Windows 2003 server, Novell server, local notebook hard disk), not sure that's going to be the issue.

I will also test the virus scanning issue, but I know on at least one server (if not all) we've specifically suppressed the checking of the VFP file types (DBF, CDX & FPT) and they're getting similar results.

Thomas on your LAN comments, I thought most Web Connection installs had the web app on a separate web server and the data that's being accessed on another. I haven't posted that on Westwind yet, but will later today.

If my understanding is correct, then the VFP web connect app is running on the web server and I assume that's where all the caching is taking place. And I'm not seeing any benefit of the cached data on the web server in a production environment (unlike on my notebook where the second time around the queries are processed in an very acceptable 4 to 5 seconds round trip). They're ALWAYS slow in production. I do appreciate the issue of dragging the data across the LAN, but then that doesn't explain the poor performance on my notebook.

Unfortunately, this is NOT an area that I have any expertise in (understanding how the caching works, etc.), so I could be completely wrong and willing to listen to any suggestions.

Kevin