> I just ran this query
>
> select p.* from tblPrintjobs p , (select oid from tblPrintjobs limit 25
> offset 622825) as subset where p.oid = subset.oid
>
I'm just curious here, from a social point of view. How often do you think
someone will paginate over say 300K rows in steps of 25 ?
The way I
I just ran this query
select p.* from tblPrintjobs p , (select oid from tblPrintjobs limit 25 offset 622825) as subset where p.oid = subset.oid
And it seems to be a bit faster than without the subselect, probably because I'm only getting one column.
The speed gain is not that high though
On 24 J
Hi,
Indeed, I would have to do it through a function, where I check the number of pages,
It puts my weakest point in the middle then.
I could simply rewrite my query like you state, just to check.
I think all my queries are on one table only. (I report in a website on one table, that has b
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
Yves Vindevogel wrote:
Hi again all,
My queries are now optimised. They all use the indexes like they should.
However, there's still a slight problem when I issue the "offset" clause.
We have a table that contains 600.000 records
We display them by 25 in the webpage.
So, when I want the last p
On 6/24/05, Yves Vindevogel <[EMAIL PROTECTED]> wrote:
> 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, an
Hi again all,
My queries are now optimised. They all use the indexes like they should.
However, there's still a slight problem when I issue the "offset" clause.
We have a table that contains 600.000 records
We display them by 25 in the webpage.
So, when I want the last page, which is: 600k / 25
