http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html says
you must retrieve all the rows even if you determine in mid-retrieval that you've found the information you were looking for.
My question is: why?
Because there is no provision in the client/server protocol whereby the client can interrupt a transfer from the server that has started.
In fact I thought that the normal interface for a database would show a screen full of results and then let you decide whether to go on to the next screen or quit. It seems crazy that if you do a query that gives a million results you have to retrieve them all.
If you're really making the server do all the work of retrieving a million rows, especially for an interactive program, you might consider rewriting the query. For example, with LIMIT.
Anyway, if you call mysql_free_result(), it will take care of retrieving and discarding and unfetched rows.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]