Everytime I clear all the caches, the process takes too long. This is from the log to a prod site I am currently working with.
368829 | [someuser] | dbname | Query | 3376 | updating |
DELETE FROM cache_page WHERE expire != 0 AND expire <= 1370891317
As you can see, it was executing for 3376 seconds. I am wondering if this is a known issue, or it is simply because there is just too much in that table.
Also, is there anything I can do to improve this?