[kofoid]

Help!

godaddy shut my site down due to this mod and it's so so awesome! It seems that the following queries caused Go Daddy's CPU utilization soar to over 80% and almost brought down the entire shared server:

SELECT gallery, threadid, firstpostid, Yadathread.title, attachmentid, Yadaattachment.dateline FROM Yadaattachment, Yadathread, Yadaforum
WHERE gallery='1' AND Yadathread.featured!='1' AND Yadathread.forumid=Yadaforum.forumid AND Yadathread.firstpostid = Yadaattachment.postid AND Yadaattachment.dateline < 1151690651
GROUP BY Yadathread.threadid
ORDER BY Yadaattachment.attachmentid DESC LIMIT 5 |
SELECT gallery, threadid, firstpostid, Yadathread.title, attachmentid, Yadaattachment.dateline FROM Yadaattachment, Yadathread, Yadaforum
WHERE gallery='1'AND Yadathread.featured!='1' AND Yadathread.forumid=Yadaforum.forumid AND Yadathread.firstpostid = Yadaattachment.postid AND Yadaattachment.dateline < 1151690653 ORDER BY RAND() LIMIT 5 |

SELECT gallery, threadid, firstpostid, Yadathread.title, attachmentid, Yadaattachment.dateline FROM Yadaattachment, Yadathread, Yadaforum
WHERE gallery='1' AND Yadathread.featured!='1' AND Yadathread.forumid=Yadaforum.forumid AND Yadathread.firstpostid = Yadaattachment.postid AND Yadaattachment.dateline < 1151690653

Can anyone let me know what I can do in order to KEEP this mod on my site? It seems that the above queries are the forumhome ones for the display 5 random images option.... is that right? If so, is there ANY way I can get this to work without as many queries?