Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataGridView RowCount setting very slow
Message
From
28/10/2008 15:21:49
 
 
To
28/10/2008 14:41:15
General information
Forum:
ASP.NET
Category:
Forms
Environment versions
Environment:
VB 9.0
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01357256
Message ID:
01357821
Views:
24
>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
Map
View

Click here to load this message in the networking platform