Re: Mupltple pages queries

Hi,

Does it depend on webserer or database server? The reason I asked this quetion is that if for example assume one book added to amazon during execution of a query by client which asks for all the books in Amazon, and such a book goes to the page 4 of the resutls (assume resutls are order by title of the book) and the client already had retrieved pages 1 to 3 of the resutls, Can he see that newly added book when he asks for the 4th page of the results?

DA Morgan wrote:
> jack.smith.sam_at_gmail.com wrote:
> > Hi All,
> >
> > If you you want you to design a website using a database server you can
> > design a query in the way that it returns answers in multiple pages.
> >
> > For example for returning all the books on amazon, the resutls are in
> > the multiple pages. Now assumed that website is designed. My quetion is
> > if such a query is designed by website admin and some client issued
> > that query on the website, how the results are shown to the user:, i.e.
> > is the result all computed by the DB server and cached and then
> > returned to the user or is the first multiple pages of the query answer
> > is cached and then returned to the user or some another approach?
> >
> > Thanks,
> > Jack
>
> In Amazon's case the work is done in the middle-tier. I suspect that
> is the choice most use.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group
Received on Tue Sep 12 2006 - 18:27:33 CDT