NAME Class::DBI::Search::Count - return count of results rather than results SYNOPSIS use base 'Class::DBI'; __PACKAGE__->add_searcher( search_count => 'Class::DBI::Search::Count' ); my $recent = CD->search_count(year => 2005); This is equivalent to, but, as the counting is done at the database rather than in perl, faster than: my $recent = CD->search(year => 2005)->count; DESCRIPTION This is a simple search plugin for Class::DBI to return a count of results rather than the results themselves. METHODS add_searcher __PACKAGE__->add_searcher( method_name => 'Class::DBI::Search::Count' ); As with all Search plugins you can choose the method name for the search that it generates. sql We override the SQL to be our own COUNT(*) version run_search We override this to return our count rather than the search results. AUTHOR Tony Bowden BUGS and QUERIES Please direct all correspondence regarding this module to: bug-Class-DBI-Search-Count@rt.cpan.org COPYRIGHT AND LICENSE Copyright (C) 2005 Tony Bowden. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.