Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Peter Rabbitson
Jorge Gonzalez wrote: Hi, I'm developing an app with Catalyst 5.80024, on perl 5.8.8, 32 bits; DBIx::Class models. > I experienced very bad performance: index pages loading in 30 seconds or more, and Catalyst reporting that the request took 40s and the like. Completely unbearable. After

Re: [Dbix-class] Multiple DBs, one Schema to rule them all

2011-02-28 Thread Mike South
On Fri, Feb 11, 2011 at 7:20 PM, Trevor Leffler wrote: > Hello, > > I am investigating whether DBIC has support for switching between logical > databases (ala 'use db1; ...; use db2; ...;'). I've a situation where there > exist many cloned databases (same DDL), one per customer. The current mode

Re: [Dbix-class] Multiple DBs, one Schema to rule them all

2011-02-28 Thread Steve
I second that thought. I was advised to do it this way from some experienced Catalyst-ers. On 2/28/2011 12:01 PM, Wes Cravens wrote: On 2/11/2011 7:20 PM, Trevor Leffler wrote: Hello, I am investigating whether DBIC has support for switching between logical databases (ala 'use db1; ...; use d

Re: [Dbix-class] Multiple DBs, one Schema to rule them all

2011-02-28 Thread Wes Cravens
On 2/11/2011 7:20 PM, Trevor Leffler wrote: Hello, I am investigating whether DBIC has support for switching between logical databases (ala 'use db1; ...; use db2; ...;'). I've a situation where there exist many cloned databases (same DDL), one per customer. The current model is that all custome

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Jorge Gonzalez
Yes and yes. :-) Jorge González Villalonga Director Técnico DAIKON Integración y Desarrollo S.L. Telf: (+34) 91 188 08 28 Fax: (+34) 91 632 65 42 www.daikon.es El 28/02/11 16:34, Peter Edwards escribió: On 28 February 2011 15:27, Jorge G

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Peter Edwards
On 28 February 2011 15:27, Jorge Gonzalez wrote: > Oooops, my fault: > > DBIx::Class: version 0.08123. > > Multiple tables -> OK, but _lots_ of tables? I tend to associate "multiple" > with something in the couples, perhaps tens. But for >100 I tend to speak > about "lots" :-) > > You are using

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Jorge Gonzalez
Oooops, my fault: DBIx::Class: version 0.08123. Multiple tables -> OK, but _lots_ of tables? I tend to associate "multiple" with something in the couples, perhaps tens. But for >100 I tend to speak about "lots" :-) Regards J. Jorge González Villalonga Director Técnico

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Peter Rabbitson
Jorge Gonzalez wrote: Hi, I'm developing an app with Catalyst 5.80024, on perl 5.8.8, 32 bits; DBIx::Class models. Also you didn't mention the most important factor - which version of DBIx::Class itself were you using? There are currently no known slowdowns while working with multiple table

Re: [Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Nigel Metheringham
On 28 Feb 2011, at 14:39, Jorge Gonzalez wrote: > - My perl (5.8.8) is a bit old (comes with Centos 5), could this issues be > solved in later versions of perl? I know C3 is integrated in basee perl in > latest versions... You have been keeping up with updates of RHEL/Centos? http://search.cpa

[Dbix-class] Performance degradation due to Class::C3

2011-02-28 Thread Jorge Gonzalez
Hi, I'm developing an app with Catalyst 5.80024, on perl 5.8.8, 32 bits; DBIx::Class models. I have used the exact same environment to develop other apps and didn't find performance problems, but now I do. The other applications were based on a simple local-running MySQL schema, with few tabl