[Ghostt]

i just try to figure out how to fix this issue i have atm this query running 20 times with
600 query length

server has 8 cores running 2 websites.(wordpress and vbulletin)




.
i just installed mysql workbench and checked this long querys.

they are ALL from the same (sub )FORUmid 1101 only this forum has 750 000 threads.

-- Connection Id: 209656
-- Host: localhost
-- Command: Query
-- Time: 481
-- State: Sorting result
SELECT  thread.threadid,
			thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
			
		FROM vbthread AS thread
		
		
		WHERE forumid = 1101
			AND sticky = 0
			
			 AND visible = 1 
					
			
			
		ORDER BY sticky DESC, thread.dateline DESC
		LIMIT 165260, 20

what can i do to prevent this query to process for testing? ive allready deactivated all setting if forum management . like thread views, search indexing, set forum incative, etc..
and i still see this query with forumid 1101

/edit
now i noticed that most slower querys 1-20 length atm are not "Sorting result" .
they are "sending data"

-- Connection Id: 275535
-- Host: localhost
-- Command: Query
-- Time: 8
-- State: Sending data
SELECT  thread.threadid,
			thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
			
		FROM vbthread AS thread
		
		
		WHERE forumid = 1101
			AND sticky = 0
			
			 AND visible = 1 
			
			
			
			
		ORDER BY sticky DESC, lastpost DESC
		LIMIT 544080, 20

_____________________________________

i checked debug in forumdisplay with id 1101.

i think this is the query:

SELECT  thread.threadid,
	thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
	
FROM vbthread AS thread


WHERE forumid = 1101
	AND sticky = 0
	
	 AND visible IN (0,1,2)
	
	
	
	
ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 20

/edit
also tested without forumdisplay.php shothread.php this query still apear.



this url for example loads very long: forumdisplay.php?f=1101&order=desc&page=101


maybe server managers assumption was right that vbthreads or some else table need innondb because it cant handle that mutch posts.

--------------- Added [DATE]1403468724[/DATE] at [TIME]1403468724[/TIME] ---------------

so paul you also dont know what this query does exectly and how to fix? or at least test somehow to exclude this forum to process this query.