How would the God of Standard Sql - Celko do server side paging?
- From: sqlguru@xxxxxxxx
- Date: Mon, 11 May 2009 07:44:54 -0700 (PDT)
On a very large database, how would Celko implement paging. Would he
send millions and millions of rows to the application layer to page
and sort OR would he do the paging on the database side (on the order
of magnitude times faster).
To do paging on the database side, you must use some sort of ordering/
ranking.
However, if he does paging on the database side, he is now
automatically contradicting himself because he said
"But look at how many new SQL programmers use IDENTITY, GUID, ROWID,
or
other auto-numbering vendor extensions to get a key that can be used
for
locating a given row -- they are imitating a magnetic tape's
sequential
access. It lets them know the order in which a row was added to the
table -- just like individual records went onto the end of the tape!"
- Celko
And also, "ordering/ranking" is automatically a sequential operation
(a magnetic tape system) according to Celko.
.
- Follow-Ups:
- Prev by Date: Re: Query Summation Question...
- Next by Date: Re: Calculating cumulative totals
- Previous by thread: Celko never responds when challenged by Tony, why?
- Next by thread: Re: How would the God of Standard Sql - Celko do server side paging?
- Index(es):
Relevant Pages
|
