<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Jul 28, 2006, at 7:39 AM, Gerhard Killesreiter wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">147.989<SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>1.08<SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>137<SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>cache_get<SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>DELETE FROM cache WHERE expire != D</FONT></P> </BLOCKQUOTE><BR></DIV><DIV>I ran tests deleting from a cache of CivicSpaceLabs.org with 10, 000 rows in the cache.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>delete from cache where expire != D<DIV>1.57 second 10K rows</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>delete quick from cache where expire != 1154158000;</DIV><DIV>Query OK, 10170 rows affected (0.96 sec)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>optimize table cache;</DIV><DIV>1 row in set (0.21 sec)</DIV><BR class="khtml-block-placeholder"></DIV>Drupal's cache has around 80, 000 rows, 3500 pages, so I think it might be worthwhile to use delete.<BR><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Cheers,</DIV><DIV>Kieran</DIV></BODY></HTML>