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] <[email protected]> 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: [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/
_______________________________________________
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/