Hi Naomi
>I don't know if you saw my yesterday's messages in the different thread. My colleague gave me an idea to access data through VFPOleDb to make sure that queries are run on the server.

Saw it but was silent as I have not much hands on expirience connecting via OleDb/ODBC. My Assumption is that speed gains there come from less network traffic, so my hint about a network sniffer in this thread could work for that thread as well.

Your test scenario should encompass:
repeated calls on open table
call on table not previously opened
test with a brand new vfp session and tables not previously opened
test with a freshly booted OS

and each test
as single remote table user and
as second remote table user.

since different cache levels might come into play.

Do a mathematical dry run in front considering bandwidth
and needed data sizes to calculate the effect of different
LAN bottleneck sizes and run the test with 10/100[/1000]MBit.

I have watched vfp sometimes loose much speed when not being the
single remote file user and this seems to stem from at least
to some degree to a non-linear increase in network traffic.
IN the vfp client server book a similar difference between
remote access and normal vfp is mentioned.

HTH

thomas