<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#FFFFFF"
text="#000000">
<div class="moz-cite-prefix">On 05/08/2014 02:09 PM, Vincent de
Phily wrote:<br>
</div>
<blockquote cite="mid:2347827(dot)4qtYvNo0j6(at)moltowork" type="cite">
<pre wrap="">The problem is that sometimes (once every few days at about 2-300K queries per
day) I get many more rows than the max 5000 I asked for (I've seen up to 25k).
And I'm getting timeouts and other problems as a result.
</pre>
</blockquote>
I would bet you have another copy of the code running without the
limit. Maybe on a cron job.<br>
To prove this, modify the log statement slightly and see if this
statement is really returning more then 5000 rows.<br>
<pre wrap="">LOG.debug("1 - Fetched %d rows", rlen) or similar.
</pre>
<br>
</body>
</html>