Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC
Message
De
27/10/1997 08:50:34
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Québec, Canada
 
 
À
24/10/1997 17:48:25
Andy Roth
Neyenesch Printers
Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00056591
Message ID:
00056789
Vues:
38
>>>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
Fil
Voir

Click here to load this message in the networking platform