[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?