I was not clear, sorry... for portals like vbIndex, vbAdvanced, etc. only. :)
The forums are always ok...

Guys, let me know if you have any portal software installed that give you those weird results. Thanks.

Don't like portals much, i want to see the forums right away.
Which is why i installed the sidebar hack, so it shows a nice left sidebar with some links, rss feeds and arcade news (and a poll as soon as i find out how to add one there) and all my forums to the right next of it.

Mysql % never goes above 15%, most of the time it's like 11-12 %.

I am recieving the same error. I am running vbIndex dunno if thats an issue here or not.

Parse error: parse error in /home/nytalk/domains/nytalk.net/public_html/board/includes/functions.php on line 1941

Reeve, the code posted above simply adds a colspan, if you have enabled the style dropdown.
The code was tested in a unhacked board. Please try it in a unmodified board and you will see there are no problems.
If vbIndex creates any problems, I would recommend you to contact the hack author for a workaround.

In the same time, I recommend to all portal users to ask the authors how to reduce the usage of MySQL database.
I saw people using VBportals (like vbIndex, vbAdvanced, etc) who stress to server up to 90% usage... [high]Is really intense.[/high] A normal MySQL usage should be around 10-15%.

Is all in how you write the code, IMO... and you can have the same results... it doesn't have to be intense for the server.
Take a look at those results and let me know what you think.

Regards,
Floren.

Ive just started to get a problem with this showing 100.00% PHP - 0.00% MySQL ..., but with x queries ... anyone seen this problem before ?

EDIT:// Apologies - my bad - I had forgotten to re-edit db_mysql.php after the 3.0.1 upgrade ...

My goodness. ;)

Where you been, my friend? ;)

I know I know ;)

[high]* Natch eats some more humble pie for breakfast
[/high]

Been busy busy d00d .... trying to survive while not making money is not the easiest thing :)

Hello,

after reading the first page and the description i am a little bit concerned. When a guest visits my VBindex portal page i have stats like: 30,23% PHP - 69,77% MySQL.

When i log in as the admin i got stats like 25,72% PHP - 74,28% MySQL.

So i have 2 questions:

1. Any experiences with vbindex portal so far why the MySQL stats are so high ? I know that this should not be placed in this thread but i would like to know if someone has got the same experience with this portal ?

2. which is clearly related to this hack: Why do my stats increase when i log in as admin ? The number of queries stay the same with 16 queries as before.

My loading time for the portal is always 0.7 seconds which i would say is fine.

Any help would be appreciated.

Cheers,

Hi Pseudomizer,
From my experience with this type of portals, I could explain why the MySQL is high.
Normally, the MySQL % is a lot higher then the vBulletin pages because the intense table scans.

VB is very intelligent in this area, it avoids to do full table scans and also it uses a very judicious system cache. All this results in a very low database usage and, indirectly a very low server usage.

Let me be more explicit.
For every option you enable in those portals, you perform extra queries, for each member that access instantly the page. The more members view in the same time the front page, the higher is the stress on the server.
So, if I enter your portal site, in an instance, the software will perform several queries that scan FULLY the hole tables in your database.

A good rule to keep in mind for coders is this: ALWAYS avoid full table scans, is the worst thing in the world.
If you have a very small forum with 200-300 posts, that will not really count, since your database is very small, but what do you do with huge forums who have 1 million posts?
Let's take as example "the x latest threads". The query will perform a full scan from ALL forums and ALL threads. I'm sure you understand why the MySQL % will raise to the sky... for an instance the server will be suffocated with the flood of information it has to compile, in order to display the results, and that?s only for ONE person... imagine what will happen when 500 users will visit in the same time your front page.
What vBulletin does is this: it puts a time/date limit, limits the search for 30 threads and also it separates it only for one forum, not all. So instead of scanning the hole forum/thread tables, it selects a very small portion of it.
The result is obvious, a very small server usage... ;)

I hope that help you understand better the % usage.

Regards,
Floren.

PS. When I have time, I will release my portal version that have a very low MySQL usage.
I posted a screenshot, few posts above, so people can see that is possible to have good MySQL results. ;)

Hi Teck,

if you should go for your own portal please add me to your list. I would be more then happy to help if you need any help. Meanwhile i will try to limit the SQL queries on my current board.

Thanks for your detailed explanation. If i am successfull i will post my results for crosschecking.

Cheers,