[VirtueTech]

It appears "freddie" was right that this was not the most optimized way to go about "similar threads".

Query: SELECT

thread.threadid,thread.lastposter,thread.title,thread.postusername,thread.replycount,thread.

lastpost,thread.postuserid,
			thread.dateline,forum.title AS

ftitle,forum.forumid,forum.parentlist
			FROM thread
			LEFT JOIN forum ON (thread.forumid=forum.forumid)
			WHERE thread.threadid<>256184 AND thread.forumid IN( 192,62,186,65,64,60,187,271,59,61,138,228,127,214,265,67,68,69,70,71,72,73,74,123,142,232,137,227,66,212,145,234,166,125,216,124,215,141,231,139,229,144,233,126,213,131,219,247,129,130,218,146,235,128,217,269,270,140,230,147,236,143,221,135,225,136,226,165,168,167,164,132,220,133,222,134,223,177,178,183,267,13,190,18,162,2,1,12,15,9,4,169,25,188,29,10,19,24,23,33,31,30,53,39,55,56,172,41,42,17,7,27,37,26,16,28,20,32,38,47,179,44,173,303,22,46,45,11,5,51,170,49,50,52,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,149,150,151,152,148,153,154,155,156,157,158,159,160,161,224,174,175,171,180,3,185,264,34,204,21,195,57,304,194,197,198,199,196,200,208,205,201,202,203,268,207,210,211,266,305,273,277,289,278,274,276,275,288,293,292,291,279,286,287,285,298,282,284,290,299,302,301,300,295,297,296 )
			AND MATCH(thread.title) AGAINST ('old stock from closed store-cocker stuff, lots of redz and more')
			AND thread.open<>10
			AND thread.visible=1
			ORDER BY dateline DESC
			LIMIT 4
Time before: 0.39137995243073
Time after:  3.3633810281754

Check out the delay!

Nice try though. I was excited that you had made this hack...too bad I can't use it. Thanks anyway.