View Single Post
11-08-2014, 03:56 AM   #3
Obama320
Junior Member
 
Join Date: Nov 2014
Posts: 1
Rep Power: 0
Obama320 is getting browny points
I began checking the table designs for the post and thread tables and sure enough there were some non-standard indexes there. There have been a few previous administrators of this database so it is quite possible they modified it in the past. I saw many duplicate indexes and removed the ones that did not come stock with VB. Restarted mysql and rebuilt the tables. The query that would take 500 seconds to complete was now finishing in under 2 seconds.
Obama320 is offline   Reply With Quote