From: "JupiterHost.Net" <[EMAIL PROTECTED]> > > > Next, your op says "When very many records are found..." What is the purpose > > of your client program loading large recordsets? You should probably be > > paging the data somehow. > > Perhaps doing your queries to return only some instead of all records > will help, a great module for doing this is: > > http://search.cpan.org/perldoc?Data::Paginate >
I am using a limit clause and the sql query returns at most 20 records, but when very many records are found, the search is very slow, even if it returns only 20. I know how many of them are found, because I use found_rows() in order to show how many records would be found if no limit clause would be used. Thanks. Teddy -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
