By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,365 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,365 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.