>I am using the SQLEXEC() to select all records from a Btrieve table
>into a cursor. The speed at which it runs is not acceptable. 45sec -
>1.5 min. to load the cursor over a Novell 3.12 network. The syntax
>used is:
>lnHandle =SQLSTRINGCONNECT('DRIVER={Pervasive Software ODBC-32};
> DDFPATH=G:\Macola\data;')
>lnResults=SQLEXEC(lnHandle, SELECT FROM
>ARVENFIL','vendors')
>
>Any ideas on who to speed this up or a faster approach.
>
>Thanks
>Andy Roth
>Neyenesch Printers
>619 297 2281
>andyroth@electriciti.com


Andy

How many records are returned? and is the database index on the field.

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.
www.TrueGeeks.com