Re: [PERFORM] Speed with offset clause

2005-06-25 Thread Radu-Adrian Popescu
> 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

Re: [PERFORM] Performance - moving from oracle to postgresql

2005-06-25 Thread Radu-Adrian Popescu
> "- Oracle has one particular performance enhancement that Postgres is > missing. If you do a select that returns 100,000 rows in a given order, > and all you want are rows 99101 to 99200, then Oracle can do that very > efficiently. With Postgres, it has to read the first 99200 rows and > then d

Re: [PERFORM] Configurator project launched

2005-06-25 Thread Andreas Pflug
Greg Sabino Mullane wrote: I wonder if this could be combined with the configurator somehow. Currently, integration won't work with Perl, so maybe C for the core and Perl for the interactive part would be better. Probably so. Seems there is a bit of convergent evolution going on. When I g