Fixed Slow Query in Planet Tags

Posted Tue, 04/25/2006 - 17:00 by John Breslin

Tagged browsing should actually work instantly now on the Planet Journals sites; there was a problem with a sub-query taking ages which I've replaced (e.g. here are the general tag views from the .co.nz and .ie sites). You can also see related tags for a particular tag on the right hand side.

Comments

Working again :) Now you can

by Cloud (not verified) - 04/26/2006 - 18:52

Working again :)

Now you can do multiple tags.

I spoke too soon - just found

by Cloud (not verified) - 04/26/2006 - 12:57

I spoke too soon - just found another query that was running all last night (and caused MySQL to b0rk) for 48056 seconds (over 13 hours). Eek!