On 7/6/06, Matija Grabnar <[EMAIL PROTECTED]> wrote: > I am concerned about the time it takes DBIx::Class to initialize with a > moderate sized database > (around 30 tables). It looks like it takes about half a second per table > - even though all the data > about the tables has been gathered by sql translator. >
Performance-improving patches welcome :) But seriously, I think you should also look at your local setup for optimizations. 30 tables in what appears to be 8 seconds seems a bit slow. Here's something for comparison: Host environment: SuSE 10.1 on a Compaq laptop (Pentium 4-M 2.2Ghz, 512MB RAM), running a Gnome desktop and Lotus Notes under Crossover Office, etc. Stock (SuSE-built) Perl 5.8.8 w/ ithreads. DBIx::Class v0.06003, all other relevant perl modules at the latest and greatest version I could manage to install. DBIC Schema: 64 ResultSource classes, plus 9 custom ResultSet classes, and 2 ResultSet base classes that some of the 9 use. Also, while your schema doesn't seem to have any relationships defined, between my 64 ResultSource classes there are a total of 126 "has_many" or "belongs_to" relationships loaded. Load time: 2.6 seconds on average -- Brandon _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
