Anatoly Lubarsky Logo
programming, design, integration, games, music

Paging ? Not here

Dino Esposito talks about new paging feature in ado.net pdc/march build


public SqlDataReader ExecutePageReader(
    CommandBehavior behavior,
    Int32 startRow,
    Int32 pageSize);

"...Instead, it declares a server cursor on the query and moves it back and forward until you close the reader. Many SQL gurus (including Microsoft's SQL gurus) disagree with this approach."

I also disagree. Sanity talk from Brian R. James :


"I must be missing something. Data-paging is the domain of the stored procedure. Why would I want to transfer thousands of records over the wire to the app server so that ADO.NET can carve up 20 and display them?"


There are many stored procedures written about how to do it right and fast. So this function has to be implemented along with appropriate stored procedures and because of that it is beyond the scope of ado.net. Let us implement it ourselves.


Related Posts:

Saturday, May 15, 2004 3:29 AM

Comments

# re: Paging ? Not here
Can you give an example of such a stored procedure?

5/15/2004 8:23 PM by Benjamin Crawford

# re: Paging ? Not here
Or an article on how to make one?

5/15/2004 8:43 PM by Benjamin Crawford

# re: Paging ? Not here
Benjamin:

ok, no problem...

5/15/2004 8:47 PM by Anatoly Lubarsky

# re: Paging ? Not here
My criteria's for using SPs paging will be (I'm sure we can find more reasons to do so) -
The client expect to see the latest updates - in this case I cannot put it in a cache (disk, RAM) on the client or on the server.
and the amount of data is huge and transferring it through the Network can be a performance penalty

Of course - when we filter the data to small portions (by date, by specific user) - SPs is not nessessary

5/16/2004 12:22 AM by Guy S

Login

Subscribe via RSS

Article Categories

.Net Framework
ASP.NET Tips
C# Win32 API
HTML, CSS, Web
Javascript Tips
MSSQL Tips
System
System.Net
WebServices

Archives

(02) January, 2018
(01) June, 2013
(03) March, 2013
(02) February, 2013
(01) July, 2012
(01) April, 2012
(01) September, 2011
(01) August, 2011
(03) May, 2011
(01) December, 2010
(01) November, 2010
(01) October, 2010
(01) June, 2010
(01) May, 2010
(02) March, 2010
(01) January, 2010
(02) December, 2009
(03) September, 2009
(03) August, 2009
(09) July, 2009
(04) June, 2009
(03) May, 2009
(02) April, 2009
(03) March, 2009
(02) February, 2009
(02) January, 2009
(04) December, 2008
(04) November, 2008
(05) October, 2008
(04) September, 2008
(05) August, 2008
(04) July, 2008
(05) June, 2008
(07) May, 2008
(04) April, 2008
(03) March, 2008
(02) February, 2008
(03) January, 2008
(03) December, 2007
(05) November, 2007
(04) October, 2007
(05) September, 2007
(12) August, 2007
(11) July, 2007
(14) June, 2007
(13) May, 2007
(13) April, 2007
(10) March, 2007
(11) February, 2007
(14) January, 2007
(14) December, 2006
(12) November, 2006
(08) October, 2006
(09) September, 2006
(06) August, 2006
(08) July, 2006
(10) June, 2006
(09) May, 2006
(22) April, 2006
(25) March, 2006
(12) February, 2006
(14) January, 2006
(19) December, 2005
(17) November, 2005
(16) October, 2005
(16) September, 2005
(12) August, 2005
(14) July, 2005
(09) June, 2005
(12) May, 2005
(12) April, 2005
(20) March, 2005
(11) February, 2005
(12) January, 2005
(18) December, 2004
(13) November, 2004
(12) October, 2004
(14) September, 2004
(09) August, 2004
(23) July, 2004
(19) June, 2004
(29) May, 2004
(19) April, 2004
(16) March, 2004
(09) February, 2004
(06) January, 2004
(02) December, 2003
(01) November, 2003

Post Categories

.Net and C#
Android
Antispam
App. Development
Architecture
ASP.NET
Blogging
Deprecated Projects
Facebook Platform
Fun
Google
iOS
Javascript
Misc.
MSSQL
Music
My Games
Performance
Roller
Social Networks
Tools
Visual Studio
Web 2.0
WebServices

About Me

linkedin Profile
Recs
Who am I

My Sites

Billy Beet
x2line blogs