Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow Asynchronous SPT
Message
De
10/11/2004 07:06:23
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
00959904
Message ID:
00959920
Vues:
8
>Hi Jörg,
>
>How is value property WaitTime of connection?
>
>MartinJ
>
>>Hi Folks!
>>
>>To show the User response while a big SPT query, I made an Asynchronous SPT Connection. Bud now the Query takes much more Time than before?! Whats wrong?
>>
>>
>>sqlsetprop(lnConnectionHandle,'Asynchronous', .T.) = 1
>>	
>>store 0 to lnZaehler, lnAnzahl, lnModulo
>>lnModulo = 60
>>	
>>* SQL Komando schicken
>>lnOK = sqlExec(lnConnectionHandle, tcSQLStatement, tcCursorname)
>>
>>do while lnOk = 0			
>>   lnOK = sqlExec(lnConnectionHandle)
>>   lnZaehler = lnZaehler + 1
>>		
>>  if mod(lnZaehler,lnModulo)=0
>>     lnAnzahl  = 0
>>  else
>>     lnAnzahl  = lnAnzahl + 1
>>  endif
>>		
>>  set message to "Abfrage wird ausgeführt "+replicate(chr(19),lnAnzahl)
>>  inkey(0.5, "H")
>>enddo
>>
>>set message to "Abfrage beendet"
>>	
>>sqlsetprop(lnConnectionHandle,'Asynchronous', .f.)
>>	
>>set message to
>>
>>
wait time = default = 100 milliseconds
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform