[Dbix-class] RFC: trimming my Muldis D talk for OSCON, PGDay next week

2008-07-16 Thread Darren Duncan
All, I've just nearly-finished writing my first talk for an international conference, a double-header of OSCON and PGDay, and I am now seeking your advance feedback to make the talk better. Especially in how to best trim it to fit in the 45 minutes of time I have. And within the next 2 days or

RE: [Dbix-class] DBIC hits DB thoguh using prefetch (repost)

2008-07-16 Thread Hartmaier Alexander
Hi Moritz! You have to use the rels the same way to prefetch them, without using the many_to_many helper (which I can't see in your code). Imho the -all is the problem. But why have the MapCategories table at all? Just store the parent or child in your Categories table! Or is it really possible

RE: [Dbix-class] Storing ResultSets in the schema

2008-07-16 Thread Hartmaier Alexander
I'd like to see a feature in dbic for this too. I have some small tables where prefetching them slows down the queries quite a lot. I load them on cat app startup, transform them to hashrefs and cache them for an hour with the caching plugin. Something in dbic which transparently allows calling

RE: REPOST: [Dbix-class] DBIx::Class and caching

2008-07-16 Thread Hartmaier Alexander
This looks promising to me (but I'm sure mst will find an argument against it ;-). If not it would be a great addition to dbic or a nice standalone module! -Alex From: Oleg Pronin [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 4:19 PM To: dbix-class@lists.scsys.co.uk Subject: REPOST: