>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