Re: faster search engine for fulltext search

From: "JupiterHost.Net" <mlists@xxxxxxxxxxxxxxx>


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


.

Relevant Pages

  • Re: faster search engine for fulltext search
    ... 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: ...
    (perl.beginners)
  • ASP Paging with Stored Procedure
    ... I am wanting to implement paging with asp & sql server 2000. ... In mysql i would simply issue a 'Limit clause such as Limit 10,1'. ... My difficulty is how do i get the starting row for my paging. ...
    (microsoft.public.inetserver.asp.db)