Hi!
Why isn‘t the gender a simple attribute but instead two different tables? -Alex From: Angel Kolev [mailto:[EMAIL PROTECTED] Sent: Saturday, December 08, 2007 4:37 PM To: [email protected] Subject: [Dbix-class] all data at once Hi, All. Im new in DBIx::Class and this is my first question here :) I write catalyst app and use dbic for 3 tables (males,females,family) with has_many and may_to_many. All works, but there are too many requests to my database when i use this: my $rs = $c->model('AppModelDB::ClientMale')->search(); while (my $line = $rs->next) { push @{$families},[ $line->client_family->first->id, make_family( $line->first_n, $line->family_n, $line->client_female->first->first_n, $line->client_female->first->family_n ) ,$line->client_family->first->city ,$line->client_family->first->zip_code ,$line->client_family->first->municipality ,$line->client_family->first->street ,$line->client_family->first->public_place_type ,$line->client_family->first->public_place_name ]; } } $c->stash->{families} = $families; I wrote "export DBIC_TRACE=1" for debug and saw alot of screens with SELECT requests to MySQL. Plese help me to optimize the code. Every single table has around 190 lines. Thank you
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
