>>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
>
>Can you be more specific please? How much records are you retreiving? What
>is the DB?
>
The files are Btrieve(*.BTR) and I am not aware of any index files
in the directory.The record count is around 1,000.
Andy Roth
Neyenesch Printers
619 297 2281
andyroth@electriciti.com