[development] Database queries on drupal.org

[Kieran Lal]

On Jul 28, 2006, at 7:39 AM, Gerhard Killesreiter wrote:

> 147.989	1.08	137	cache_get	DELETE FROM cache WHERE expire != D

I ran tests deleting from a cache of CivicSpaceLabs.org with 10, 000  
rows in the cache.

delete from cache where expire != D
1.57 second 10K rows

delete quick from cache where expire != 1154158000;
Query OK, 10170 rows affected (0.96 sec)

optimize table cache;
1 row in set (0.21 sec)

Drupal's cache has around 80, 000 rows, 3500 pages, so I think it  
might be worthwhile to use delete.

Cheers,
Kieran
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20060729/c465c5eb/attachment.htm