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: [EMAIL PROTECTED] To: Elim Qiu Cc: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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.
