Controlling the server -> client fetch size

[Mallard Crowe]

I see that mysql_use_result() and mysql_store_result() allow you to retrieve results into the client memory space either a single row at a time from the server or the entire result set from the server.

Is there a way to control the fetch size so that, say, I get 100 rows back from the server at a time?

Cursors would probably do the trick, but then you can't build things in 'C'.

Thanks,