Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLCommit() vs sending COMMIT via SPT
Message
De
10/11/2010 03:11:53
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
10/11/2010 02:27:43
Dennis Lim
D-Labs, Inc.
Manila, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: SQLCommit() vs sending COMMIT via SPT
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01488689
Message ID:
01488691
Vues:
53
>Hi Experts,
>
>Is there a performance boost in using VFP's SQLCOMMIT() function as against sending an actual COMMIT statement via SPT? Which is the preferred choice?

Using SQL 2005 Express I've found that SqlCommit() doesn't decrease the @@trancount on SQL side, it stays 1 forever, which leaves me unsure of its success. So I gave it up and went to sqlexec(h, "commit transaction").
back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform