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/

Reply via email to