Re: sql in php with paging -- WEB400

Subject: Re: sql in php with paging
From: Nathan Andelin <nandelin@xxxxxxxxx>
Date: Wed, 22 Oct 2008 07:57:24 -0700 (PDT)
List-archive: <http://archive.midrange.com/web400>
List-help: <mailto:web400-request@midrange.com?subject=help>
List-id: Web Enabling the AS400 / iSeries <web400.midrange.com>
List-post: <mailto:web400@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=unsubscribe>

From: "Burke, Joel"
I would love to be able to use LIMIT and OFFSET but from what
I have read so far, it is not possible with DB2.

Well, DB2 may not support the LIMIT and OFFSET clauses natively, but the question is whether they're supported in the mySQL storage engine for DB2, where the application is connecting to mySQL, but storing the data in DB2.

But even if they were supported, how would performance be? It's clear that the technique is easy to use from a programming perspective, but what's going on underneath?

Nathan.

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.