List Info

Thread: Re: C::M::DBIC::Schema::QyeryLog: can't collect any stats...




Re: C::M::DBIC::Schema::QyeryLog: can't collect any stats...
country flaguser name
Italy
2007-09-19 10:32:17
Cory Watson ha scritto:
> On 9/19/07, Marcello Romani <mromaniottotecnica.com> wrote:
>> Do you use it in cat apps on in plain dbic ?
>>
>> Could you provide an example of usage ?
> 
> http://www.onemogin.com/bl
og/554-profile-your-catalystdbixclass-app-with-querylog.html

> 
> The syntax has changed a bit due to the Analyzer, but
you should be
> able to make the leap.
> 

Thank you, but I had read that article before.
While interesting and useful, it doesn't provide any code
example on how 
to actually use dbic::querylog in a cat app (I read the 
$schema->debugobj($ql_instance) and $schema->debug(1)
instruction, but 
where do I exactly put them in a cat app, since the cat
model's 
connection is delayed until needed ?).

I went on with my tests, and I think your suggestion was
right.
If I put this line in the TT template:

[% querylog %]

I get something like DBIx::Class::QueryLog=HASH(0x93b48a8)
where the hash address changes every time I refersh the
page.
I think the address should be the same, otherwise I always
get a fresh 
object which of course doesn't have any statistics in it...
Right ?

-- 
Marcello Romani
Responsabile IT
Ottotecnica s.r.l.
http://www.ottotecnica.com


_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )