[almannai]

Originally Posted by janslu

Hi almannai,

Few days have passed and my database is still having problems with increased load after the upgrade. I get repeated errors like this one:

SELECT block.*,
blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
blocktype.description as blocktypedescription, blocktype.allowcache
FROM block AS block
LEFT JOIN blocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
WHERE 1 AND block.active = 1 AND blocktype.productid IN ('everywhere_sidebar','GaduGadu','vbblog','crawlability_sitemap','crawlability_vbseo','evbs_sstab_advanced','_vboptimise_dbtech','welcome_headers4t','eparate','vsa_sfm','sevenskins_imageresizer','gallery','psi_smqre','dp_sphinx_search','vbulletin','')
ORDER BY block.displayorder, block.title;

It was working better with version 1.1.2 but I have troubles getting the old version to work with vb 4.1.7. Can you think of any way to speed up the process of rendering the sideblock? What may be the reason of query number increase between 1.1.2 and 1.4.4.4?

I didn't test it on vb4.1.7 am still on 4.1.5, once upgrade and get this error I will upgrade the mod.

For the slowness you need to decrease the number of blocks for max of 6 and use different blocks for different forums and/or pages.

Edited:
One of the guys checked 1.4.4.4 on 4.1.7 and it's ok. Check your settings!