[Dbix-class] paging question
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
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.
perl -Mre=debug -e "/just|another|perl|hacker/"
More information about the DBIx-Class