<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Hi Hugh,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">I assume this is for Apache and I’m running IIS7, so I guess it isn’t compatible?</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">“</span>It looks like I've been having performance problems because millions of rows get blessed into objects, not sure of this but it looks like a DBIC thing
at the moment.”<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">That’s not good, and is part of the issue of ORM (so I’ve read), I’m not as old as you, but I’m still old school, get only the columns and rows you need
when you need them, well that’s my take on it and it seems to work for me.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Craig.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Hugh Barnard [mailto:hugh.barnard@gmail.com]
<br>
<b>Sent:</b> 30 October 2012 15:47<br>
<b>To:</b> The elegant MVC web framework<br>
<b>Subject:</b> Re: [Catalyst] Global 'helper' methods</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi <br>
<br>
On measurement in general, I'd recommend: Devel::NYTProf::Apache ; there's a write up here:<br>
<a href="http://www.slideshare.net/bobcatfish/profiling-with-develnytprof">http://www.slideshare.net/bobcatfish/profiling-with-develnytprof</a>
<br>
<br>
I'm dealing with a largish Catalyst/mod_perl thing at the moment and it's been tremendously helpful. One tip is that it is very picky about closing the files that it needs to compile the profiles, I write these into /tmp and then crunch them with the command
line tools.<br>
<br>
Incidentally, I am 62 and therefore pretty old-skool and not mad for ORM-everywhere. It looks like I've been having performance problems because millions of rows get blessed into objects, not sure of this but it looks like a DBIC thing at the moment. Currently
I've 'cursor'-ed them:<br>
my $cursor = $entries->cursor;<br>
while ( my @row_values = $cursor->next ) {<br>
and that seems to give some improvements in that area...<br>
<br>
Best regards Hugh</p>
<div>
<p class="MsoNormal">On 30 October 2012 15:24, Lukas Thiemeier <<a href="mailto:spamcatcher@thiemeier.net" target="_blank">spamcatcher@thiemeier.net</a>> wrote:</p>
<p class="MsoNormal">Hm... how to measure the overhead of a module?<br>
<br>
There is a XS version of the module which is used if you have a C<br>
compiler. I don't know the exact overhead, but I know that it is fast.<br>
<br>
I have no experience with the pure perl version of that module.<br>
<br>
If all you have to do with the dates is the simple string transformation<br>
you are right. As I said before: I recommend to use DT if you are<br>
working with dates a lot. Doing math on dates and times is annoying,<br>
because of leap years, epochs, timezones and so on. If you need this:<br>
Using DateTime is recommended. If not: Its not :)<br>
<br>
If you are ONLY using pure perl modules:<br>
You can include all required modules in your distribution. It should run<br>
on any perl installation, even in a shared host environment.<br>
<br>
App::FatPacker helps you doing this...<br>
<br>
But this doesn't work as soon as you use XS modules.</p>
<div>
<div>
<p class="MsoNormal"><br>
On 10/30/2012 04:03 PM, Craig Chant wrote:<br>
> Thanks Lukas,<br>
><br>
> I appreciate there is DateTime , though I have so much legacy code that uses my helper class re-writing everything will be a mammoth task.<br>
><br>
> I hand rolled a lot when I first started out with Perl, didn't know much about CPAN or PPM, and couldn't load any modules that weren't part of the core install on the original 'shared' hosting I was using.<br>
><br>
> Plus I always felt loading an entire module to re-arrange a tiny string seems a bit OTT?<br>
><br>
> Dunno, what's the overhead of DateTime?<br>
><br>
> Craig.<br>
><br>
> -----Original Message-----<br>
> From: Lukas Thiemeier [mailto:<a href="mailto:spamcatcher@thiemeier.net">spamcatcher@thiemeier.net</a>]<br>
> Sent: 30 October 2012 14:52<br>
> To: <a href="mailto:catalyst@lists.scsys.co.uk">catalyst@lists.scsys.co.uk</a><br>
> Subject: Re: [Catalyst] Global 'helper' methods<br>
><br>
> You can also define your constants in "YourApp/Constants.pl", and "use"<br>
> YourApp::Constants wherever you need them.<br>
><br>
> YourApp/Constants.pm:<br>
> use constant { FOO => 1 };<br>
> 1;<br>
><br>
> Controller.pm:<br>
><br>
> use YourApp::Constants;<br>
><br>
> # and in some method<br>
> ...<br>
> my $global_foo = FOO;<br>
><br>
> There might be a better way, but this works...<br>
><br>
> For handling dates, I recommend "DateTime", available on cpan:<br>
><br>
> Another reason to use DBIC:<br>
> DBIx::Class::Inflatecolumn::DateTime automatically transforms dates stored in a database into a DateTime object, which can be used like this:<br>
><br>
> my $uk_string = $datetime->dmy('/');<br>
> my $us_string = $datetime->ymd('-');<br>
><br>
> But DateTime is not related to DBIC, DBIC just makes using it easy.<br>
><br>
> Use it if you have to work with dates a lot. It has lots of methods for outputting dates, times or both in different formats, and it allows datetime-math...<br>
><br>
><br>
> On 10/30/2012 03:39 PM, Craig Chant wrote:<br>
>> Well I opted for putting my globals (methods and constants) in<br>
>> MyApp.pm<br>
>><br>
>> It's working grand with $c->myMethod or $c->MY_CONSTANT<br>
>><br>
>> I use to have them working as a bareword within my application , but $c->MY_CONSTANT is just as easy!<br>
>><br>
>> Many thanks for all the input and help, it really is appreciated.<br>
>><br>
>> -----Original Message-----<br>
>> From: Lukas Thiemeier [mailto:<a href="mailto:spamcatcher@thiemeier.net">spamcatcher@thiemeier.net</a>]<br>
>> Sent: 30 October 2012 13:56<br>
>> To: <a href="mailto:catalyst@lists.scsys.co.uk">catalyst@lists.scsys.co.uk</a><br>
>> Subject: Re: [Catalyst] Global 'helper' methods<br>
>><br>
>> Hi Craig,<br>
>><br>
>> Writing helpers in your main App.pm and using roles is not either-or.<br>
>><br>
>> Roles are one possibility to modify your classes in a reusable way.<br>
>><br>
>> If your helpers are really global, which means that they are used by all, or almost all your controllers, I would put them into your main application class.<br>
>><br>
>> If you have more than one application which make use of the same<br>
>> helpers: Put them into a role:<br>
>><br>
>> YourHelperRole.pm:<br>
>><br>
>> package YourHelperRole;<br>
>> use Moose::Role;<br>
>><br>
>> has "some_attribute" => ( ... ); # if you need attributes<br>
>><br>
>> sub helpermethod1{<br>
>> my ($self, $other, $args) = @_;<br>
>> do_something();<br>
>> }<br>
>><br>
>> sub helpermethod2{<br>
>> my ($self, $other, $args) = @_;<br>
>> do_something_different();<br>
>> }<br>
>><br>
>> no Moose::Role; # or use namespace::autoclean or MooseX::MarkAsMethod<br>
>> 1;<br>
>><br>
>> App.pm:<br>
>><br>
>> use Catalyst qw( ... );<br>
>> extends "Catalyst";<br>
>> with qw/YourHelperRole/;<br>
>><br>
>> ...<br>
>><br>
>> In my opinion, extending your main App.pm with roles is only useful if you need the same helpers in different locations, too.<br>
>> If you only need them for that single application, avoid the overhead related to using roles.<br>
>><br>
>> If you have helpers which are only needed by some controllers, create a role for your controllers. You can not only implement helpers in you roles, you can also create method-modifiers, which change the way your methods behave.<br>
>><br>
>> Here is an example, which writes sth to the log, after the "delete"<br>
>> method was called:<br>
>><br>
>> YourLogRole.pm:<br>
>><br>
>> package YourLogRole;<br>
>><br>
>> use Moose::Role;<br>
>> requires qw/delete/; #die if the consuming class has no "delete"<br>
>><br>
>> after "delete" => sub{<br>
>> my ($self, $c) = @_;<br>
>> $c->log->debug("DELETE called");<br>
>> };<br>
>><br>
>> no Moose::Role;<br>
>> 1;<br>
>><br>
>> Controller1.pm: (has the helpers, but no logging)<br>
>><br>
>> package Controller1;<br>
>> use Moose;<br>
>> extends "Catalyst::Controller";<br>
>> with qw/<br>
>> YourHelperRole<br>
>> /;<br>
>><br>
>> sub someaction :Local {<br>
>> my ($self, $c) =@_;<br>
>> $self->helpermethod1();<br>
>> }<br>
>><br>
>> ...<br>
>><br>
>> Controller2.pm: (has helpers AND logging)<br>
>><br>
>> package Controller2;<br>
>> use Moose;<br>
>> extends "Catalyst::Controller";<br>
>> with qw/<br>
>> YourLogRole<br>
>> YourHelperRole<br>
>> /;<br>
>><br>
>> sub delete :Local :Args(1) { ... }<br>
>><br>
>> Controller3.pm (has logging, but no helpers)<br>
>><br>
>> package Controller3;<br>
>> use Moose;<br>
>> extends "Catalyst::Controller";<br>
>> with qw/<br>
>> YourLogRole<br>
>> /;<br>
>><br>
>> sub delete :Local :Args(1) { ... }<br>
>><br>
>> Roles are very powerful tools. I use them a lot.<br>
>> Read the Moose docs for more information.<br>
>><br>
>> If you don't want to learn Moose, roles and so on now, just remember:<br>
>><br>
>> 1. write sth in a role<br>
>> 2. consume the role in a moose class, using "with"<br>
>> 3. your roles methods and attributes will be available in the<br>
>> consuming class<br>
>><br>
>> Lukas<br>
>><br>
>> On 10/30/2012 02:03 PM, Craig Chant wrote:<br>
>>> Hi,<br>
>>><br>
>>><br>
>>><br>
>>> Please could you advise the best way of having a global 'helper'<br>
>>> class that has all commonly used methods in it accessible for any<br>
>>> part of the catalyst app.<br>
>>><br>
>>><br>
>>><br>
>>> I found this thread<br>
>>> <a href="http://stackoverflow.com/questions/11941836/catalyst-global-subroutin" target="_blank">
http://stackoverflow.com/questions/11941836/catalyst-global-subroutin</a><br>
>>> e<br>
>>> s<br>
>>><br>
>>><br>
>>><br>
>>> With one indicating it's ok to put them in the main MyApp.pm and<br>
>>> another saying to use Moose & Roles.<br>
>>><br>
>>><br>
>>><br>
>>> What is considered the correct way and could you provide an example<br>
>>> of how I create this helper class and bolt it to the Catalyst application.<br>
>>><br>
>>><br>
>>><br>
>>> Many thanks,<br>
>>><br>
>>><br>
>>><br>
>>> */Craig Chant/*<br>
>>><br>
>>> I.T. Manager<br>
>>><br>
>>> Description: <a href="cid:image001.png@01CD5F4A.17E848D0">cid:image001.png@01CD5F4A.17E848D0</a><br>
>>><br>
>>> Main Line 01903 602664<br>
>>><br>
>>> Direct Line 01903 227753<br>
>>><br>
>>> Visit our website <a href="http://www.homeloanpartnership.com" target="_blank">
http://www.homeloanpartnership.com</a><br>
>>><br>
>>> *HomeLoan Partnership have been named the Best Mortgage Network,<br>
>>> 2012, at the <a href="http://myintroducer.com" target="_blank">myintroducer.com</a> Industry Awards*<br>
>>><br>
>>><br>
>>><br>
>>> This Email and any attachments contain confidential information and<br>
>>> is intended solely for the individual to whom it is addressed. If<br>
>>> this Email has been misdirected, please notify the author as soon as<br>
>>> possible. If you are not the intended recipient you must not<br>
>>> disclose, distribute, copy, print or rely on any of the information<br>
>>> contained, and all copies must be deleted immediately. Whilst we take<br>
>>> reasonable steps to try to identify any software viruses, any<br>
>>> attachments to this e-mail may nevertheless contain viruses, which<br>
>>> our anti-virus software has failed to identify. You should therefore<br>
>>> carry out your own anti-virus checks before opening any documents.<br>
>>> HomeLoan Partnership will not accept any liability for damage caused<br>
>>> by computer viruses emanating from any attachment or other document supplied with this e-mail.<br>
>>> HomeLoan Partnership reserves the right to monitor and archive all<br>
>>> e-mail communications through its network. No representative or<br>
>>> employee of HomeLoan Partnership has the authority to enter into any<br>
>>> contract on behalf of HomeLoan Partnership by email. HomeLoan<br>
>>> Partnership is a trading name of H L Partnership Limited, registered<br>
>>> in England and Wales with Registration Number 5011722. Registered<br>
>>> office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership Limited<br>
>>> is authorised and regulated by the Financial Services Authority.<br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
>>> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
>>> Searchable archive:<br>
>>> <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
>>> Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
>><br>
>><br>
>> _______________________________________________<br>
>> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
>> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
>> Searchable archive:<br>
>> <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
>> Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a> This Email and any attachments<br>
>> contain confidential information and is intended solely for the<br>
>> individual to whom it is addressed. If this Email has been<br>
>> misdirected, please notify the author as soon as possible. If you are<br>
>> not the intended recipient you must not disclose, distribute, copy,<br>
>> print or rely on any of the information contained, and all copies must<br>
>> be deleted immediately. Whilst we take reasonable steps to try to<br>
>> identify any software viruses, any attachments to this e-mail may<br>
>> nevertheless contain viruses, which our anti-virus software has failed<br>
>> to identify. You should therefore carry out your own anti-virus checks<br>
>> before opening any documents. HomeLoan Partnership will not accept any<br>
>> liability for damage caused by computer viruses emanating from any<br>
>> attachment or other document supplied with this e-mail. HomeLoan<br>
>> Partnership reserves the right to monitor and archive all e-mail<br>
>> communications through its network. No representative or employee of<br>
>> HomeLoan Partn<br>
> ership ha<br>
> s the authority to enter into any contract on behalf of HomeLoan Partnership by email. HomeLoan Partnership is a trading name of H L Partnership Limited, registered in England and Wales with Registration Number 5011722. Registered office: 26-34 Old Street,
London, EC1V 9QQ. H L Partnership Limited is authorised and regulated by the Financial Services Authority.<br>
>><br>
>> _______________________________________________<br>
>> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
>> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
>> Searchable archive:<br>
>> <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
>> Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
><br>
><br>
> _______________________________________________<br>
> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
> Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
> Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a></p>
</div>
</div>
<p class="MsoNormal">> This Email and any attachments contain confidential information and is intended solely for the individual to whom it is addressed. If this Email has been misdirected, please notify the author as soon as possible. If you are not the intended
recipient you must not disclose, distribute, copy, print or rely on any of the information contained, and all copies must be deleted immediately. Whilst we take reasonable steps to try to identify any software viruses, any attachments to this e-mail may nevertheless
contain viruses, which our anti-virus software has failed to identify. You should therefore carry out your own anti-virus checks before opening any documents. HomeLoan Partnership will not accept any liability for damage caused by computer viruses emanating
from any attachment or other document supplied with this e-mail. HomeLoan Partnership reserves the right to monitor and archive all e-mail communications through its network. No representative or employee of HomeLoan Partn</p>
<div>
<div>
<p class="MsoNormal"> ership ha<br>
s the authority to enter into any contract on behalf of HomeLoan Partnership by email. HomeLoan Partnership is a trading name of H L Partnership Limited, registered in England and Wales with Registration Number 5011722. Registered office: 26-34 Old Street,
London, EC1V 9QQ. H L Partnership Limited is authorised and regulated by the Financial Services Authority.<br>
><br>
> _______________________________________________<br>
> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
> Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
> Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
<br>
<br>
_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br clear="all">
<br>
-- <br>
<a href="http://www.hughbarnard.org" target="_blank">http://www.hughbarnard.org</a><br>
<a href="http://www.twitter.com/hughbarnard" target="_blank">http://www.twitter.com/hughbarnard</a><br>
<a href="http://www.big-wave-heuristics.com/" target="_blank">http://www.big-wave-heuristics.com/</a></p>
</div>
This Email and any attachments contain confidential information and is intended solely for the individual to whom it is addressed. If this Email has been misdirected, please notify the author as soon as possible. If you are not the intended recipient you must
not disclose, distribute, copy, print or rely on any of the information contained, and all copies must be deleted immediately. Whilst we take reasonable steps to try to identify any software viruses, any attachments to this e-mail may nevertheless contain
viruses, which our anti-virus software has failed to identify. You should therefore carry out your own anti-virus checks before opening any documents. HomeLoan Partnership will not accept any liability for damage caused by computer viruses emanating from any
attachment or other document supplied with this e-mail. HomeLoan Partnership reserves the right to monitor and archive all e-mail communications through its network. No representative or employee of HomeLoan Partnership has the authority to enter into any
contract on behalf of HomeLoan Partnership by email. HomeLoan Partnership is a trading name of H L Partnership Limited, registered in England and Wales with Registration Number 5011722. Registered office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership
Limited is authorised and regulated by the Financial Services Authority.
</body>
</html>