Neil;
Tried the cleanup you've mentioned... As I've suspected it didn't help much.
Not sure what do you mean about the DNS on the server. The network is a small Win2003 server with 5 XP stations. There are also some win98 stations which don't use the server. The server is very fast with other processes including VFP itself. The SQL thing is driving me nuts because I can achieve the exact same results using xbase command and get it in no time. So it just gotta be something on the VFP side.
I have since tried to see if my selects are rushmore optimized and they are not. I have ran a very simple sql select query on a simle index and found out it is not optimized.
Select * from ruginv where status = "ST000"
The table has an index on status.
I'm baffled.
Thanks,
Alen.