http://rt.cpan.org/Public/Bug/Display.html?id=23760
The call from a template to a resultset's result_source.columns
generates a SELECT COUNT( * ) FROM __TABLE__ me:. For PostgreSQL, the
SELECT COUNT(*) takes as long as
half a second.
$c->stash->{items} =
$c->model('MyApp::Books')->search(undef, {
rows => 3,
}),
[% FOREACH column IN items.result_source.columns %]
<th>[% column %]</th>
[% END %]
Sorry for the vagueness and lack of a test case. I've just gone
through my first DBIC tutorial a few hours ago and through the first
usage of Catalyst with DBIC today. castaway and ash on #dbix-class
confirmed the issue.
Hope that helps,
Vlad Dan Dascalescu
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
