467,915 Members | 1,842 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Does GridView paging feature limit number of records coming back from database?

I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean, the
paging feature isn't somehow making calls to the database for 25 records at
a time or anything like that is it?

I remember in the past having to write nasty stored procedures that took in
what the last record was and how many to return to manually handle this sort
of thing without dumping 100,000 records all at once.

But does the GridView's paging feature truly do this?

Thanks for any insight,
Ron
Apr 15 '07 #1
  • viewed: 3461
Share:
3 Replies
Hi,

You are correct, the standard paging does not reduce the server side result
set. And you need to use custom paging to achieve a more optimal solution
esp. for very large result sets. Of course SQL Server 2005 offers very nice
feature to support paging of queries.

Hope this helps

--
Chris Taylor
http://dotnetjunkies.com/weblog/chris.taylor
"Ronald S. Cook" <rc***@westinis.comwrote in message
news:ey**************@TK2MSFTNGP03.phx.gbl...
>I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean,
the paging feature isn't somehow making calls to the database for 25
records at a time or anything like that is it?

I remember in the past having to write nasty stored procedures that took
in what the last record was and how many to return to manually handle this
sort of thing without dumping 100,000 records all at once.

But does the GridView's paging feature truly do this?

Thanks for any insight,
Ron

Apr 15 '07 #2
you can use dataset for such a feature
in .net 2005 it supports
you can call da.fill(ds,starting indx, number of records ,and
somenthin)
May 6 '07 #3
On Apr 15, 8:16 pm, "Chris Taylor" <chris_taylor...@hotmail.com>
wrote:
Hi,

You are correct, the standard paging does not reduce the server side result
set. And you need to use custom paging to achieve a more optimal solution
esp. for very large result sets. Of course SQL Server 2005 offers very nice
feature to support paging of queries.

Hope this helps

--
Chris Taylorhttp://dotnetjunkies.com/weblog/chris.taylor

"Ronald S. Cook" <r...@westinis.comwrote in messagenews:ey**************@TK2MSFTNGP03.phx.gbl. ..
I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean,
the paging feature isn't somehow making calls to the database for 25
records at a time or anything like that is it?
I remember in the past having to write nasty stored procedures that took
in what the last record was and how many to return to manually handle this
sort of thing without dumping 100,000 records all at once.
But does the GridView's paging feature truly do this?
Thanks for any insight,
Ron- Hide quoted text -

- Show quoted text -
Note, the GridView does an optimized paging with the ObjectDataSource
control.

How Paging Works in the GridView Control
http://msdn2.microsoft.com/en-us/library/5aw1xfh3.aspx

May 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by news.microsoft.com | last post: by
8 posts views Thread by AG | last post: by
8 posts views Thread by Greg Lyles | last post: by
2 posts views Thread by rn5a | last post: by
reply views Thread by news.ipartners.pl | last post: by
1 post views Thread by rbrowning1958 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.