Yes, the tables have indexes (including one for DELETED()) and SYS(3054,1) shows FULL Rushmore optimisation. Using a Win95 PC as the server on the same network only cuts a few seconds off the time taken.


>>Hi, the following VFP 5.0a program takes on average 20 secs to read under 500 records. The files are on a SCO Unix server with the "samba" network agent connected to Win95 PC's over a 10MB network connection. A VFP "browse" for the same files and fields is almost instantaneous.
>>------------------------------------------------------
>>USE "\\unix\disk1\maindata\crd\crdmst.dbf" IN 0 SHARED
>>USE "\\unix\disk1\maindata\z\zdna.dbf" IN 0 SHARED
>>
>>nTIME=DATETIME()
>>
>>SELECT crdmst.name, ;
>>ALLTRIM(pstl_adr_1)+','+ALLTRIM(pstl_adr_2) as address, ;
>>ALLTRIM(pstl_city)+','+ALLTRIM(pstl_state)+pstl_pcode as city, ;
>>balance,creditor FROM crdmst,zdna INTO CURSOR cdm NOCONSOLE ;
>>WHERE crdmst.creditor == zdna.code ORDER BY 1
>>
>>=MESSAGEBOX("Time:"+STR(DATETIME()-nTIME)+" Seconds")
>>
>>CLOSE TABLES
>>------------------------------------------------------
>>Any help would be deeply appreciated. I'd hate to contemplate VC/VB or Delphi.
>>
>>Rgds
>>Petras
>
>Hi,
>
> Do you have proper indexes on table?.
>
>Bye
>Jayesh