On 3 February 2010 22:50, Peter Rabbitson <[email protected]> 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/" _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
