>>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement