>>>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
It shouldn't be so long to retrieve records. Check more about index it should help a lot. I don't know much about BTrieve.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only