Is there a recommended or enforced maximum # of columns in the 2.0 GridView?

I have a view with 32,000+ rows and 39 columns that I am displaying using
the GridView control. With paging enabled, the time it took to move between
pages was in the range of 2 to 5 minutes. The bottleneck was probably the
size of the DataSet used by the SqlDataSource control. I changed SELECT *
FROM VIEW_NAME to SELECT <just the list of 9 fields that I need to display>
FROM VIEW_NAME, which must have significantly reduced the size of the
DataSet. The time it took to traverse pages was reduced to just 2 to 3
seconds.
Thank you.

I have more and I get it quick...

I used the article under 4guysfromrolla...

your problem is that tyou are getting (very time you change the page) all
the 32000+ records!

check this link:

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)


"Mark Peacock" <MarkPeacock (AT) discussions (DOT) microsoft.com> escreveu na mensagem
news:05D21804-9B01-4F0A-9152-10DF8EFF4839 (AT) microsoft (DOT) com...