MyBB

ok i have this statistic on index

Generated in 7.1853662 seconds (10.13% PHP / 89.87% MySQL)
SQL Queries: 155 / Global Parsing Time: 1.1369560 / Memory Usage: 2.25 Mb
PHP version: 5.2.10 / Server Load: 0.46 / GZip Compression: Enabled

How to speed it up and why i have 155 Queries. I saw mybb forums with 9 Queries?

Please help

It could be because of plug ins. What plug ins do you have installed?

Tip: Board Settings>>Server and Optimization Options>>Advanced Stats / Debug information>>Check yes. Now on your index page, go all the way to the bottom and click Advanced Details. It will list every query.

You must have alot of plug-ins that are enabled or plug-ins that are not optimized very well.

Here is my debug...

I think anywhere that you see this in a header "Plugin Hook" means a the query is from a plug in. You also have a few queries that are not very optimized and these queries look like plug ins.

Deactivate ALL your plugins and try it without any plugin activated.

The fastest query in your list is 0.04 seconds, the slowest 0.26 seconds. This is mostly a problem with your database since (SET NAMES 'utf8') that is not even a query takes 0.05 seconds for you. 20 queries like that and you'll already have page generation times of over 1 second. And that's the number of queries you get without plugins.

Your root issue is that your database is simply too slow to be useful. Disabling your plugins can be a workaround to make the forum less laggy while you're talking to your host about the slow database problem. If they can't provide you with a database that has normal speeds, switch to a different (more reliable) host.