On Tue, Aug 18, 2009 at 5:24 PM, Matthias Dietrich<[email protected]> wrote: > > you could ask a single question on the irc channel like I do ;-): > irc.perl.org#dbix-class
Ooh, I might give that a go when I have a minute! (And at the right time of day) > Though I don't know the answer, maybe the deflate and inflate hooks can call > SQL functions? But for dates you can use Perl functions or define your > column as datetime (see: DBIx::Class::InflateColumn::DateTime). I was hoping to be able to do it as part of the query when it gets the rest of the normal columns, since one of the reasons was to reduce multiple calls to the DB (or other routines). And DateTime was what got me pulling my hair out to investigate this alternative in the first place! A simple query with a dozen lines was taking around 2 seconds to return, and I'd put in an extra method, which was doing some DateTime calls. Without calling that method, the request took a much more reasonable 300ms. In the end I found the culprit was because I set a timezone of "local" - if I hard-coded it to my actual timezone, it was fast, but using "local", was slow-as, even though it translated to the same thing! > Also good luck from me! Thanks! -- Trevor Phillips - http://dortamur.livejournal.com/ "On nights such as this, evil deeds are done. And good deeds, of course. But mostly evil, on the whole." -- (Terry Pratchett, Wyrd Sisters) _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
