Environment versions
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......
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only