Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Advantage of OLE DB over SPT
Message
 
À
20/03/2006 11:52:30
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01105891
Message ID:
01105918
Vues:
53
In my experience ODBC tended to be a little faster when dealing with iSeries, this may have changed in recent years. The following article has some benchmark data for OLEDB vs ODBC.

http://www.redbooks.ibm.com/abstracts/SG245183.html?Open



>OLE DB is supposed to be faster and consume fewer resources than ODBC (which is used by SPT).
>
>Disadvantage is that the results are returned in an ADO record set and may need to be converted to a cursor before use in VFP.
>
>>What are the advatages of using OLE DB over SPT and what does it require?
>>
>>I main objective is getting and putting data to an iSeries(AS400) database.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform