[Dbix-class] Checking on prefetching w/limits issue

Matt S Trout dbix-class at trout.me.uk
Fri Dec 8 21:57:00 GMT 2006


On 8 Dec 2006, at 17:33, Hill, Woodrow J wrote:

> Hi!
>
> I wanted to double-check if there were still issues with
> paging/limits/offsets with prefetched data, as per the quote below:
>
> 'As soon as you prefetch a has_many we've got no effective way to  
> handle
> the limit/offset as yet; "needs subselects, hopefully in 08"'

You're on 07001. That's not 08 :)

So yeah, has_many prefetch with LIMIT is still unlikely to do what  
you want. Sorry.

-- 
Matt S Trout, Technical Director, Shadowcat Systems Ltd.
Offering custom development, consultancy and support contracts for  
Catalyst,
DBIx::Class and BAST. Contact mst (at) shadowcatsystems.co.uk for  
details.
+ Help us build a better perl ORM: http://dbix- 
class.shadowcatsystems.co.uk/ +





More information about the Dbix-class mailing list