Versions des environnements
Network:
Windows 2008 Server
>Viv,
>
>>Setting the ColumnCount *after* the RowCount should help some......
>
>Thank you.
>This solves the issue.
>now I have only 4 sec delay which is caused by loading two cached pages and running SELECT COUNT(*).
>8 sec delay is gone.
Hi,
Hmmm. Not sure about the extent of the improvement. Prior to my post I just did a quick test using your posted code (but swapping the two statements) and noticed an improvement. I've just added code to show timings and, on my machine, the delay dropped by about 50% (from 6 to 3 seconds) but there's still that 3 sec delay for the basic code......
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement