<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Feb 4, 2010, at 1:04 AM, Xavier Perseguers wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi Ries,<br><br><blockquote type="cite"><blockquote type="cite">((scheduled BETWEEN 1265068628 AND 1265068828 ) OR scheduled <=<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">1265068728) AND NOT exec_time AND page_id=1 AND parameters_hash =<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">'854e9a2a77'<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">OT:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">This looks like a horrible query...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">((scheduled BETWEEN 1265068628 AND 1265068828 ) OR scheduled <=<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">1265068728)<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Why not do<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">(scheduled BETWEEN 0 AND 1265068828 )<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Or simply...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">(scheduled <= 1265068728)<br></blockquote><br>Ask the crawler team... ;-)<br><br>But if you read it carefully (I wrote it as it appears in my logs), you'll notice that the OR part does not contain the same timestamp as the second operator of the BETWEEN. There's some grace/sleeping period when running the crawler and I guess this is somehow related...<br><br></div></blockquote></div><br><div>Crap yeaa... I see it now,</div><div><br></div><div>still a horrible query though, databases don't like OR, whish was my main catch...</div><div><br></div><div>Ries</div><br><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 12px;"><span class="Apple-style-span" style="font-size: medium;"><br></span></span></font><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="font-size: 12px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline"></span></span> </div><br></body></html>