Tweet
I know the CMS has been criticised for large numbers of queries, including by the VB staff, and addressed to some extent in VB 4.1.11, but....
I have section pages with 6 article previews in (screenshot below, page here). The number of queries is extreme - 300+ with normal VB, and about 150 with vboptimse installed (the number of queries varies strangely - I assume related to caching).
Also something that seems odd to me is a huge number of permissions checks that show in the messages area at the bottom of the debug:
(unspecified) fetch_permissions(133, 1, 6); -> cached fperms for forum 133
(unspecified) fetch_permissions(50, 1, 6); -> cached fperms for forum 50
(unspecified) fetch_permissions(12, 1, 6); -> cached fperms for forum 12
There must be about hundred of these entries, one for each forum I assume. I have these even though there is no forum related content or block on the page.
The result is a very heavy and slow page. With nice low server loads page generation times of 0.5 - 1 second for forum pages, but roughly 3 seconds for these CMS section pages.
I use a single lighttpd/fast-cgi webserver and two database servers in mysqli_slave config. All have low loads and no errors. VB 4.2 PL2.
Is this a case of 'oh, they all do that, sir' or do I have a problem? VB staff comment really appreciated and if a problem then suggestions of where I might start in sorting it out.
Thanks!
I have section pages with 6 article previews in (screenshot below, page here). The number of queries is extreme - 300+ with normal VB, and about 150 with vboptimse installed (the number of queries varies strangely - I assume related to caching).
Also something that seems odd to me is a huge number of permissions checks that show in the messages area at the bottom of the debug:
(unspecified) fetch_permissions(133, 1, 6); -> cached fperms for forum 133
(unspecified) fetch_permissions(50, 1, 6); -> cached fperms for forum 50
(unspecified) fetch_permissions(12, 1, 6); -> cached fperms for forum 12
There must be about hundred of these entries, one for each forum I assume. I have these even though there is no forum related content or block on the page.
The result is a very heavy and slow page. With nice low server loads page generation times of 0.5 - 1 second for forum pages, but roughly 3 seconds for these CMS section pages.
I use a single lighttpd/fast-cgi webserver and two database servers in mysqli_slave config. All have low loads and no errors. VB 4.2 PL2.
Is this a case of 'oh, they all do that, sir' or do I have a problem? VB staff comment really appreciated and if a problem then suggestions of where I might start in sorting it out.
Thanks!
