Java OutOfMemoryError and heap - limit records returned.

[Cloverswift Solutions]

We have the Variman RETS 3.2.4 server and have been running it for awhile now.  Every so often a user does a query that will return all records from one of our tables.  This causes the Java OutOfMemoryError heap message with callstack to show up in the log.  The problem is that once this happens, the Variman server no longer responds and all users are locked out.  I've set record limits using groups for users (currently set to 10,000).  However, when examining the native queries it seems there is no "limit" clause (I'm using MySQL).  So it appears Variman is trying to grab all the records from the query and then do the limit (is this correct?).  Is there a configuration to prevent Variman retrieving more the X records from a table?  Thanks!