How do I index the search that returns more than a thousand records with
several parameters? My server runs pretty slow on a search like that.
In the DBIx::Class::ResultSet, I found there is way to do indexing, but it's
not very clear, so, would someone please help me out. I'm using MySQL database.
The base class of the table is:
----------------------------------------------
package myDB::HTMLLinks;
use base qw/DBIx::Class/;
# Load required DBIC stuff
__PACKAGE__->load_components(qw/PK::Auto Core/);
# Set the table name
__PACKAGE__->table('htmllinks');
# Set columns in table
__PACKAGE__->add_columns(qw/
id
link
activel
/);
# Set the primary key for the table
__PACKAGE__->set_primary_key(qw/id/);
--------------------------------
What do I need to add in this class, and in the controller that calls the
search?
Thank you.
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search._______________________________________________
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]
