469,642 Members | 1,169 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,642 developers. It's quick & easy.

Record Paging

Hello,

I am converting an ASP page to ASP.Net. In one page, I am using record
paging. I have read that while the DataGrid control has paging, it can tax
resources. So I did a Google and found and example of using the Repeater
control (http://aspnet.4guysfromrolla.com/art...091003-1.aspx). My
question is at approximately how many records does it make sense to not use
the DataGrid control, or should I always use something like the example
website that I provided? I'm just trying to get a feel for what other users
have experienced.

--
Thanks in advance,

Steven
Nov 18 '05 #1
2 1242
If you have several hundred records or less then the standard datagrid
paging will likely work acceptably for most projects. (Ultra high volume
sites with extreme scalability needs are excluded from this statement.)
If you are dealing with more records than that, then you'll need to analyze
your available server power, infrastructure and performance needs to see if
the standard datagrid will still work for you or not.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Steven K" <sk****@troop.com> wrote in message
news:ub****************@TK2MSFTNGP10.phx.gbl...
Hello,

I am converting an ASP page to ASP.Net. In one page, I am using record
paging. I have read that while the DataGrid control has paging, it can tax resources. So I did a Google and found and example of using the Repeater
control (http://aspnet.4guysfromrolla.com/art...091003-1.aspx). My
question is at approximately how many records does it make sense to not use the DataGrid control, or should I always use something like the example
website that I provided? I'm just trying to get a feel for what other users have experienced.

--
Thanks in advance,

Steven

Nov 18 '05 #2
You can implement custom paging with your data grid control fairly easily.

The strategy I employ is to select the rows from the database into a table
variable that has an auto-increment integer as an extra column.

The sproc that's doing this takes in the page number and page size and then
figures out from what range of records to select from the table variable.

This approach is probably your best bet aside from adding an auto-increment
column to all tables that will be paged when returned.

RMD
"Steven K" <sk****@troop.com> wrote in message
news:ub****************@TK2MSFTNGP10.phx.gbl...
Hello,

I am converting an ASP page to ASP.Net. In one page, I am using record
paging. I have read that while the DataGrid control has paging, it can tax resources. So I did a Google and found and example of using the Repeater
control (http://aspnet.4guysfromrolla.com/art...091003-1.aspx). My
question is at approximately how many records does it make sense to not use the DataGrid control, or should I always use something like the example
website that I provided? I'm just trying to get a feel for what other users have experienced.

--
Thanks in advance,

Steven

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by monki | last post: by
2 posts views Thread by Hrvoje Vrbanc | last post: by
1 post views Thread by Hai Nguyen | last post: by
2 posts views Thread by asad | last post: by
1 post views Thread by asad | last post: by
reply views Thread by Edwin Knoppert | last post: by
9 posts views Thread by =?Utf-8?B?UHJhdmlu?= | last post: by
2 posts views Thread by rn5a | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.