>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