>Hi Naomi
>>27 seconds for both cases on network database. There are no users of it currently.
>
>compared to 3 secs locally seems a bit hefty.
>I'Ld build a small network under my control (just 2 PC's connected via switch or crosspatch]
>verify and perhaps use filemon or a network tracer/sniffer.
>
>HTH
>
>thomas
Hi Thomas,
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.
Also I was pointed to
http://www.vfpserver.com/downloads.htm that may give us what we want. However, the description on the site in English is not sufficient for me to make a decision to look into it closely and try it. I asked my Spanish speaking colleague to look into help files and give me more info. It will take sometime before he can do it, though, because he has other work priorities...
If it's not broken, fix it until it is.
My Blog