Re: Paging using XSLT

[Bharat dot Chintapally at CommerceQuest dot com]

<Steve>
From: "Steve Muench" <Steve.Muench@oracle.com>
Subject: Re: Paging using XSLT

| Wouldn't it be easier to simply paginate the
| XML before it gets to the translator? ie.
| throw windows of XML data at the translator
| and translate for each page?

>Indeed. I've been out to several customers who've tried
>to do this "paging" in one way or another with XSLT. The least
>efficient way I've observed is a customer who was
>querying 25,000 rows of database data into XML
>(using the Oracle XML SQL Utility) and then using
>top-level stylesheet parameters and <xsl:if> elements
>in their stylesheet to "filter" the data to emit
>only rows N through M of those 25000 onto the browser.
>(Where M-N is usually in the 10-15 range).
</Steve>

How did they do this? I am trying to do the same, but I do not have
so many records. I am already using a bunch of filters to reduce the
amount of data.

The "big" advantage I get by paging and sorting at the browser(/client) end
is that I do not have to hit the web_server/db_server again for the
same (sorted/paged) data.If I have to save some db hits, I may have to
cache the
data using sessions.

Well by using the browser I do not have to cache the data and I can
sort/page
on the fly.

But it is pretty complex task to come up with such functionality.
Any pointers are really appreciated.


David M. Karr else suggested using JSP's, it is same as using the Servlets
and we don't
this logic to be at the server end because of the same problems I mentioned
above.

Thanks
-- bharat
---------------------------------------------------------------
Bharat Chintapally
CommerceQuest Inc.
bharat.chintapally@commercequest.com
New Phone # 813-639-6478
---------------------------------------------------------------




 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list