Hi list. I'm a mysql supporter (it's really fast, indeed!). I've read some messages about static or dynamic cursors. Is there any of you who can answer the following question?

There are some situations in which I query the mysql database with complex queries and I'd like to see only some rows. If I like them, then I'll ask more (and so on...). I know that one solution is to use "LIMIT"..., but in that case mysql server has to again do all the computations and so on... and I don't want to unnecessarily overload the server. If such a possibility exist, please tell me. Thanks.