Здравствуйте, Angel.
Вы писали 8 декабря 2007 г., 18:36:55:
|
> |
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 |
Use 'join' or 'prefetch' attribute for search. Also see the Cookbook http://search.cpan.org/~ash/DBIx-Class-0.08008/lib/DBIx/Class/Manual/Cookbook.pod#JOINS_AND_PREFETCHING
--
С уважением,
dreel mailto:[EMAIL PROTECTED]
_______________________________________________ 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]
