[Dbix-class] paging question

demerphq demerphq at gmail.com
Wed Feb 3 22:17:08 GMT 2010


On 3 February 2010 22:50, Peter Rabbitson <rabbit+dbic at rabbit.us> wrote:
> The only thing that can be prepare_cached are parametrized queries
> (where the query stays the same and only the bindvalues for ? change).
> Limits are currently not expressed via ?'s and it is rather hard to
> do so in SQLA. Let us know if PG supports bind values for the
> limit/offset specification, so we know if an effort is warranted at
> all.

Id say an effort is warranted in eliminating any use of offset. :-)

I mean, if you use limit/offset then you are effectively paging the
full data set and throwing away the first $offset records.

Which isnt going to perform at all acceptably on even a modestly large data set.

cheers,
Yves


-- 
perl -Mre=debug -e "/just|another|perl|hacker/"



More information about the DBIx-Class mailing list