[Catalyst] DBIx makes Catalyst startup painfully slow

[Neo [GC]]

Ok I've tried it (base class with __PACKAGE__->load_components()) and 
after some fiddling around, I learned that it's not good to save the 
file in MyApp/lib/MyDB/. ;)

This speeded up my app start from 12 seconds to 8 seconds, what is much 
more acceptable. Considered that 4 seconds are the app itself, the model 
loading speeded up by 50%, what is really nice for such a simply tweak.

I'm afraid this is all I can get out of it, as I don't have any fancy 
load_classes-stuff or anything in my models, just definitions like 
table(), add_columns(), has_many(), belongs_to() aso.
If someone knows further tweaking, please be free and post it! :)


Btw: My main schema constists of 148 tables with a rather complex 
layout. Every foreign key constraint is included.

I wonder what magic DBIx does in the remaining 4 seconds... In another 
project - written in PHP - I have models with similar functionality 
created by a self-written class, which is executed at every request and 
takes about 0.05 seconds on the same machine...


Greets and regards,
Thomas Weber



Neo [GC] schrieb:
> Ah thanks, this is very interesting!
>
> I will try and report back.
>
>
> (btw: static schemas of course)
>
> Eden Cardim schrieb:
>> On Tue, Feb 10, 2009 at 7:53 AM, Neo [GC] <neo at gothic-chat.de> wrote:
>>  
>>> Is this normal? Is there _any_ way to speed things up? Does anyone 
>>> know,
>>> what DBIx even does the whole time
>>> (probing the database or something)?
>>>     
>>
>> http://www.grokbase.com/topic/2007/08/17/dbix-class-startup-speed/tcXHEoyXXwHvcI5RppiTmCiHg4g 
>>
>>
>>   
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: 
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/