Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Exec (Asynchonous Vs Synchornous)...
Message
De
25/08/2006 17:39:24
 
 
À
25/08/2006 12:54:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Divers
Thread ID:
01148643
Message ID:
01148736
Vues:
19
>For the same query by sql pass-through, when I use asynchronous mode, I got the result in 80 seconds, and synchronous mode in less than 5 seconds. How to explain that's so longer by asynchronous mode?

because the backend must execute the whole select, it store the result into a temporary table.
When the client read the data,
the backend has to pick them up from the temporary table.
This require an overhead.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform