[wp-trac] [WordPress Trac] #20316: Garbage collect transients

[WordPress Trac]

#20316: Garbage collect transients
----------------------------+------------------
 Reporter:  nacin           |       Owner:
     Type:  task (blessed)  |      Status:  new
 Priority:  normal          |   Milestone:  3.7
Component:  Database        |     Version:
 Severity:  normal          |  Resolution:
 Keywords:  needs-patch     |
----------------------------+------------------

Comment (by pento):

 I'm cool with attachment:20316.diff​. It took me a little while to parse
 how the query worked, so it'd be worth including a comment explaining what
 it's doing.

 The other way of doing this (if making the query simpler was the goal)
 would be to have a query to find all the transients we need to delete,
 then generate the `DELETE` query in PHP. That felt fairly fragile, would
 result in a bunch more code, and is probably slower, so I think the single
 query `DELETE` is the best way to go.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/20316#comment:59>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software