Re: [Dbix-class] ★ VOTE NOW: DBIC Governance and Namespace Control ★

Proposal A JJ Allen Software Delivery Manager Drury House Drury Lane Rugby CV21 3DE T: 01788 298 411 M: 07747 63 23 43 E: j...@opusvl.com W: www.opusvl.com ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC

Re: [Dbix-class] Chaining multiple many-to-many relations

ications", you need to address the actual result object. e.g. my $groups = $rowUser->groups; while ( my $group = $groups->next ) { my $applications = $group->applications; while ( my $app = $applications->next ) { # doing awesome app stuff } } Hope that helps. - jon __

Re: [Dbix-class] updating a has_many relationship failure

> It expects the object of the opposing table row there, not a hash - hence the > error.  This is how I would do it. Thanks David, works great now. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

[Dbix-class] updating a has_many relationship failure

e are the relevant versions I am using, perl 5.8.8 DBIx::Class : 0.08115 Catalyst : 5.80015 Any ideas? Am I doing something wrong, or could an older version of perl be the problem? Thanks! - Jon ___ List: http://lists.scsys.co.uk

Re: [Dbix-class] many to many insert

> This version is more than 7 months old. Upgrade. Yep, that fixed it. Jeez, dumb mistake by me. At least I learned about DBIC_MULTICREATE_DEBUG. Thanks! - Jon ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.

Re: [Dbix-class] many to many insert

> What version of DBIC. Also show the column definitions for the 3 sources > involved. Also do you have a set_primary_key everywhere? Also provide > what Eden asked for. DBIx::Class - .08103 Here is a slimmed down definition for the three relevant tables, package App::Schema::Result::Songs; __PA

[Dbix-class] many to many insert

ails to create the writers_songs record, even if the writers already exist. I ran a trace to see what is going on, and this is what I gathered, It tries to select from writers_songs, SELECT me.writer, me.song, me.publisher, me.percentage FROM writers_songs me WHERE ( ( me.song = ? AND me.writer IS

Re: [Dbix-class] How I hate (some) DBAs

Let me rephrase, then: Has your DBA profiled his Oracle set-up to demonstrate that the DBIC database calls are such a significant component of database load that they need to be optimised? I'd be calling for some hard data on which a sensible decision can be made. Regards, -- Jon S

Re: [Dbix-class] How I hate (some) DBAs

Hi Ian, Have you profiled your code to demonstrate that the calls to DBIC are an insignificant component of the overall request cycle time, and as such choosing a more "efficient" technology is a waste of time, effort and money? I have used PL/SQL. Dark, terrible days, those. Regards

Re: [Dbix-class] MySQL "OR" Performance for Large Query Sets

On Sun, 2008-11-16 at 13:48 +0100, demerphq wrote: > 2008/11/16 Jon Schutz <[EMAIL PROTECTED]>: > > I've just done some benchmarking on MySQL 5 for queries where you need > > to select back many individual records, e.g. you could use > > > > SELECT ... WHERE

Re: [Dbix-class] MySQL "OR" Performance for Large Query Sets

On Mon, 2008-11-17 at 12:15 -0500, Jason Gottshall wrote: > demerphq wrote: > > 2008/11/16 Jon Schutz <[EMAIL PROTECTED]>: > >> I've just done some benchmarking on MySQL 5 for queries where you need > >> to select back many individual records, e.g. you c

[Dbix-class] MySQL "OR" Performance for Large Query Sets

h spec such as A => [ 1 .. 1000 ] into (A=? OR A=? ... ) 1000 times, which could be a real gotcha (indeed, some of my own code, which I shall now be reviewing, can expect arrays of tens of thousands of keys...). I was wondering - has anyone else seen similar behaviour? -- Jon Schutz

Re: [Dbix-class] Proposal for hook into deploy()

On Sat, 2008-02-23 at 11:47 +, Ash Berlin wrote: > > > > Any comments or suggestions of a better way? > > > > -- > > > > Jon > > > > > Yes, how about this: > > http://search.cpan.org/~jrobinson/DBIx-Class-0.08009/lib/DBIx/Class/S

[Dbix-class] Proposal for hook into deploy()

SQL::Translator args hash (%sqltargs) parameter; the 'sources' key in sqltargs is also a non- standard arg so there's a precedent there. Any comments or suggestions of a better way? -- Jon ___ List: http://lists.scsys.co.u

Re: [Dbix-class] dbix update and create

able DBIC_TRACE=1 to see what it's doing. -- Jon SchutzMy tech notes http://notes.jschutz.net Chief Technology Officerhttp://www.youramigo.com YourAmigo ___ List: http://lists.scsys.co.uk/cgi-bin/

Re: [Dbix-class] RFC: DBIx::Class::Fixtures

On Tue, 2008-02-05 at 17:25 -0800, Benjamin Hitz wrote: > > > Hey, uh... what's a Fixture? > I googled around a bit but that surprisingly didn't help. Pointer? > > Here's a lead: http://en.wikipedia.org/wiki/Test_fixture In short - a pre-canned database f

Re: [Dbix-class] [ANNOUNCE] DBIx::Class 0.08008

8.8-10 and up that have the bless/overload > > patch applied (badly) which causes 2x -> 100x performance penalty. > > (Jon Schutz) > > I think we can do better on the check, please consider the attached > propsed patch. > > It inhibits the warning on systems which

Re: [Dbix-class] is_foreign_key_constraint => false is ineffective

On Sat, 2007-11-03 at 13:15 +, Ash Berlin wrote: > Jon Schutz wrote: > > On Fri, 2007-11-02 at 09:31 +, Ash Berlin wrote: > > > >> Yes good point. Of course I only ever wanted it to force creating of > >> keys, not stop it. Fancy putting toget

Re: [Dbix-class] is_foreign_key_constraint => false is ineffective

tests attached. Regards, -- Jon Index: t/lib/DBICTest/Schema.pm === --- t/lib/DBICTest/Schema.pm (revision 3852) +++ t/lib/DBICTest/Schema.pm (working copy) @@ -36,7 +36,8 @@ ), qw/SelfRefAlias TreeLike TwoKeyTreeLik

[Dbix-class] is_foreign_key_constraint => false is ineffective

s_foreign_key_constraint} : $source->compare_relationship_keys([EMAIL PROTECTED], [EMAIL PROTECTED]) ) ) ... ? -- Jon ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo

Re: [Dbix-class] Why is prefetch so slow?

> > I think it's your honours to put the patch together, if you're willing to. > I was afraid you might say that. Suggested patch attached, against svn revision 3821. Regards, -- Jon Index: DBIx/Class.pm =

Re: [Dbix-class] Why is prefetch so slow?

On Thu, 2007-10-18 at 19:38 +0100, Matt S Trout wrote: > On Thu, Oct 18, 2007 at 03:03:24PM +0930, Jon Schutz wrote: > > > > According to the bug report above, the problem should be fixed in RPM > > perl-5.8.8-22 and later, so I compiled and installed perl-5.8.8-24 a

Re: [Dbix-class] Why is prefetch so slow?

On Wed, 2007-10-17 at 16:19 +0100, Nigel Metheringham wrote: > Jon, > > You should look at RH bug #196836 for information on the Red Hat > perl bug that causes this. > > https://bugzilla.redhat.com/show_bug.cgi?id=196836 > Interesting, well found. As background

Re: [Dbix-class] Why is prefetch so slow?

On Fri, 2007-10-12 at 17:01 +0930, Jon Schutz wrote: > In my code I have a DBIx::Class query with prefetch that is taking about > 1.2 seconds to execute. If I remove the prefetch, it takes 0.2 seconds. > The actual SQL query takes 0.00 seconds with or without the join. The > number o

Re: [Dbix-class] Why is prefetch so slow?

-Alex > > > > Zero time was last years (or further back.) This year was negative time. > Or does that make it last year's was negative time. Or maybe the year > before that.. > > On a more serious note, Jon: 0.00 implies that MySQL (client) has cached > that query.

Re: [Dbix-class] Why is prefetch so slow?

On Fri, 2007-10-12 at 08:51 +0100, Will Hawes wrote: > On 12/10/2007, Jon Schutz <[EMAIL PROTECTED]> wrote: > In my code I have a DBIx::Class query with prefetch that is > taking about > 1.2 seconds to execute. If I remove the prefetch, it takes >

[Dbix-class] Why is prefetch so slow?

nce there. Is anyone aware of this performance issue, or, even better, does anyone know how to fix it??? -- Jon prefetch.pl Description: Perl program ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-clas