Tweet
Hi,
We are currently in the process of migrating a fairly large custom made forum to VBulletin 5 - DB size of the migrated VB5 db is somewhere around 17GB. We're using memcached and sphinx, so almost everything is working as intended. We did notice however, that posting to certain forums takes a very long time - sometimes 15 seconds would pass until the post action would be processed.
We managed to find the query that caused most of the delay and improve performance significantly with just one additional index:
ALTER TABLE node ADD INDEX `idx_node_performance` (`parentid`,`showpublished`,`showapproved`,`lastcontent`,`lastcontentid`);
I hope this may help some people who experience similar performance issues and I'd kindly ask the developers to consider adding that index to a default install - I don't think it should have any significant negative impact, but it does help very much in case of large forums.
Kind regards
Markus
We are currently in the process of migrating a fairly large custom made forum to VBulletin 5 - DB size of the migrated VB5 db is somewhere around 17GB. We're using memcached and sphinx, so almost everything is working as intended. We did notice however, that posting to certain forums takes a very long time - sometimes 15 seconds would pass until the post action would be processed.
We managed to find the query that caused most of the delay and improve performance significantly with just one additional index:
ALTER TABLE node ADD INDEX `idx_node_performance` (`parentid`,`showpublished`,`showapproved`,`lastcontent`,`lastcontentid`);
I hope this may help some people who experience similar performance issues and I'd kindly ask the developers to consider adding that index to a default install - I don't think it should have any significant negative impact, but it does help very much in case of large forums.
Kind regards
Markus
Comment