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
_______________________________________________
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]
