All Forums Database
Vesoni 5 posts Joined 06/06
10 Jun 2006
Paging in Teradata for Web application

Hi,


I try to create fast paging in web application?
Is any SQL syntax in Teradata which is similair
to LIMIT and OFFSET in MySQL?
(Example: http://www.cgi-interactive-uk.com/ mysql_paging_results.html)

Thanks,
Vesoni

Daniel Giabbai 42 posts Joined 07/04
11 Jun 2006

Paging requires the answer set to be cached somewhere on a server. Teradata does not have this kind of facility, so you have to build your own or use one from an existing Application Servers.

Vesoni 5 posts Joined 06/06
11 Jun 2006

Hi Daniel,

Thank you for info.

Regards

You must sign in to leave a comment.