I have a table got about 200000 rows. I want my web application be able to perform search
(dynamic query on this table).
the search can be quite complex because we need to look at other tables through
relationships. So the query may be
an expensive one. But the ideal thing is to get the count of the matches and then just
fetch, say 25 rows at a time to
be displayed on a web page. And my question is, give a query, how to let mysql just return
certain number of matches?
Of course I can let the web app ignore what not be displayed (hide them, say), but there
may be expensive memory
usage and cpu usage to do so.
----- Original Message -----
From: SGreen@stripped
To: Elim Qiu
Cc: mysql@stripped
Sent: Wednesday, October 13, 2004 2:18 PM
Subject: Re: fetch certain number of matches
Could you possibly describe what you would like to find? Table
definitions, sample data, and sample queries (especially ones that you
have already tried with explanations of what was wrong with their output)
would all help us to answer your question.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Elim Qiu" <elim@stripped> wrote on 10/13/2004 03:55:35 PM:
> Is there a way to ask mysql to return certain number of matches?
> This is very useful for search functionality.
