<div dir="ltr">DBIx::Class::Schema::Loader does *a lot* of queries on your DB to introspect it, so runtime is heavily dependant on latency to your DB server....<div><br></div><div>Try tracing the queries:</div><div><br></div><div>DBI_TRACE=1 dbicdump ...</div><div><br></div><div>That should give you an idea of why it's so slow... In my experience, most of the time is spent making queries, as opposed to actually generating your result classes....</div><div><br></div><div>/L </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jul 10, 2015 at 1:19 PM, <a href="mailto:thilo.fester@googlemail.com">thilo.fester@googlemail.com</a> <span dir="ltr"><<a href="mailto:thilo.fester@gmail.com" target="_blank">thilo.fester@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div>Hello,<br><br></div>I'm just updating my model classes using dbicdump [<a href="https://metacpan.org/pod/dbicdump" target="_blank">https://metacpan.org/pod/dbicdump</a>] as I usually do. The output looks good so far -> there are no errors I could refer to.<br></div>But the script is painfully slow. I have been waiting for five hours now and the script did not finish yet. My schema has around 120 tables but as far as I remember, it never took so long before.<br><br></div>The config file looks like that ...<br><br><loader_options><br> components InflateColumn::DateTime<br> components Helper::Row::ToJSON<br> debug 1<br> db_schema MYSCHEMA<br> dump_directory ./lib<br> <naming><br> ALL v8<br> force_ascii 1<br> </naming><br> overwrite_modifications 1<br> skip_load_external 1<br> use_moose 1<br></loader_options><br><br></div>.. without connect string.<br><br></div>I am connected to an Oracle Database 12c (Release 12.1.0.2.0, 64bit). The connection is stable and Oracle is processing and delivering results pretty fast for usual queries. <br><br></div><div>My machines load average: 0,30, 0,41, 0,36<br><br></div><div>Where is the bottleneck? Did anybody observe this or a similar behaviour before?<br><br></div><div>Regards<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div>Thilo<br></div></font></span></div>
<br>_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" rel="noreferrer" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" rel="noreferrer" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br></blockquote></div><br></div>