Hmm, I can't do this, i'm afraid. Or it would be rather difficult
My query is executed through a webpage (link to the page in a navigation bar)
I do not know how many records there are (data is changing, and currently is 600k records)
The only thing I could do, is doing this in a function where I first get the page, and then decide whether to use the normal sort order or the reversed order
That would put my weak point right in the middle, which is not that bad, but I would like to find an easier way, if that is possible
Huge memory would help ?
On 24 Jun 2005, at 20:54, hubert depesz lubaczewski wrote:
On 6/24/05, Yves Vindevogel <[EMAIL PROTECTED]> wrote:Met vriendelijke groeten,
So, when I want the last page, which is: 600k / 25 = page 24000 - 1 =
23999, I issue the offset of 23999 * 25
improving this is hard, but not impossible.
if you have right index created, try to reverse the order and fetch
first adverts, and then resort it (just the 25 adverts) in correct
order.
it will be faster.
depesz
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
Met vriendelijke groeten,
Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
<x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>
Bien à vous,
Kind regards,
Yves Vindevogel
Implements
Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
Web: http://www.implements.be
<x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]