using LIMIT and OFFSET

From: ron (ron.piterma..mx.net)
Date: Tue Mar 08 2005 - 05:51:30 EST

Next message: Alex Gunawan Wibowo: "Bug in DataObjectUtils???? Re: Using DataContext not getting value in database"

Previous message: Alex Gunawan Wibowo: "Using DataContext not getting value in database"
Next in thread: Cris Daniluk: "RE: using LIMIT and OFFSET"
Reply: Cris Daniluk: "RE: using LIMIT and OFFSET"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I am aware of the paginating solution, *but*...

Performing a query, letting the database do the LIMIT and OFFSET,
instead of letting the DB return a huge resultset and paging through it
in java: isn't that a critical performance issue?

Why should'nt use OFFSET and LIMIT which are offered by the DB?

what are the issues there?

How *can* I use them using cayenne?

Cheers,
Ron

Next message: Alex Gunawan Wibowo: "Bug in DataObjectUtils???? Re: Using DataContext not getting value in database"
Previous message: Alex Gunawan Wibowo: "Using DataContext not getting value in database"
Next in thread: Cris Daniluk: "RE: using LIMIT and OFFSET"
Reply: Cris Daniluk: "RE: using LIMIT and OFFSET"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Mar 08 2005 - 05:51:35 EST