The solution (executive summary) was:

* move load_components() into a base class, use base that class on all the sources (mst suggestion); * replace custom "load_classes" loop with the basic load_classes() and a loop over sources (tracked down after a message from Hartmaier Alexander).

With this two changes, the load time is now:

[EMAIL PROTECTED]:lib $  time perl -MWG::S -e  1

real    0m2.058s
user    0m1.818s
sys     0m0.096s

Anyone had any luck getting this down below 2 secs? I have 111 (Oracle) tables running on a not-particularly-fast old Sun V880.
Going to a base class wiith "load_components('Core') shaved off 0.4 sec.

I need to cut this time down to run AJAX queries ....

Thanks,

Ben

--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO Consortium
Stanford University ** [EMAIL PROTECTED]




_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]

Reply via email to