Re: strategies for paging
- From: "Tony Rogerson" <tonyrogerson@xxxxxxxxxx>
- Date: Sat, 29 Sep 2007 09:38:22 +0100
Why are you formatting data in the back end? The basic principle of a
tiered architecture is that display is done in the front end and never
in the back end. This is a more basic programming principle than just
SQL and RDBMS.
Even a hobbyist would no better.
Google search, "rogerson", it returns 1,710,000 rows, are you seriously saying you would pass all 1.7 million rows from the SQL Server to the middle tier or client only to take the first 10?
Do you not think it makes more resource sense to select just the page of results you need and pass that back from the SQL Server instead? That would be 10 rows instead of 1.7 million going across that network link to the middle tier.
in the back end. This is a more basic programming principle than just
SQL and RDBMS.
Not sure what principles you are drawing that statement from but in my client server training I was taught to do the processing where it is most appropriate for resource and maintainability reasons.
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"--CELKO--" <jcelko212@xxxxxxxxxxxxx> wrote in message news:1191027456.763592.265890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
or any other advice? <<
Why are you formatting data in the back end? The basic principle of a
tiered architecture is that display is done in the front end and never
in the back end. This is a more basic programming principle than just
SQL and RDBMS.
.
- References:
- strategies for paging
- From: Nick Chan
- Re: strategies for paging
- From: --CELKO--
- strategies for paging
- Prev by Date: Re: find unique identifier through multiple tables
- Next by Date: Re: I want to parse @ArrayOfDays into @d1 through @d5
- Previous by thread: Re: strategies for paging
- Next by thread: Comparing two tables
- Index(es):
Relevant Pages
|
