Hello Larry,

Sounds like your where clause is not optimized, make sure there is an matching index available for your search.

Bob

>If select * from returns the entire table (over 50K records) in 0.00 seconds, can I rule out network problems? I only get the delay when I use a 'where' clause (which I always use, I'm just trying to pinpoint the problem)
>
>
>>A customer just upgraded their network from a Citrix server with Winterm workstations to a MS 2000 Server with new Dell Optiplex 170L workstations. The Visual FoxPro application is now running the SQL Selects 5 to 10 times slower than before. I have installes VFP9 and a copy of the data on the C: drive of my workstation and compared a very simple SQL command versus running on the server. I even loaded Visual FoxPro on the server to try to compare apples to apples.
>>
>>select * from Dispatch where impexp="I" took about 5 seconds on the local drive and 25 on the server to pull about 26000 records.
>>
>>Needless to say this is making parts of my application almost unusable.
>>
>>The network guy told me to replace \\server\fxapp with \\168.192.0.1\fxapp and that would eliminate any DNS issues. It made no difference. I have disables realtime monitoring on the Norton AV on the server, and uninstalled Microsoft OneCare on my workstation. Still only a slight improvement.
>>
>>I'm stumped. The customer is NOT HAPPY. Any help would be greatly appreciated.
>>
>>Larry Morelli
>>248-640-7114

'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'