>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

Petras,

Don't know anything about Unix boxes, but did you try to map your drive to some letter? In my case, with the data being on an NT server (P90...) , I notice a 6% improvement.

lnTime = SECONDS()
*OPEN DATABASE "\\Server_Vivegnis\DDV\PROSAL\PROSAL" SHARED
OPEN DATABASE F:\PROSAL\PROSAL SHARED
USE Prosal!Presence SHARED
SELECT COUNT(RECNO()) AS lnCnt FROM Presence WHERE ! DELETED() INTO CURSOR Count_Rec
lnTime = SECONDS() - lnTime
? lnTime
? lnCnt && gives 324908 records

*-- With F:\ ==> 4.527 sec
*-- With "\\Server_Vivegnis\DDV\" ==> 4.857 sec

José