discuss about phpBB3 and db high load

[mhmdkhamis]

hello every body in very good forum

i want to ask does phpBB3 will destroy db high load & alot of Queries

in db

my server will destroy soon becouse my database have very high load

i uninstall all un necessary mods

but i have big problem with my db & very big high load

i hope phpBB3 have soulation for that

any idea?

[dcz]

Destroy may be a bit too much, but yes, phpBB3 is better designed as far as DB load than 2.0.x.

But big forums will always need more resources. So in your case it depends, phpBB3 will help out, but it could end up not being enough if your forum is really bigger than your server can handle.

First thing to do could be to separate sql server and web server in case you're running a dedicated server, or to go for a dedicated if not already.

++

[mhmdkhamis]

[mhmdkhamis]

if i empety

sessions_keys table

sessions table

does that effect in every thing in my forum

[mhmdkhamis]

what can i do untiel i go to deticted server to make a load low

what do you think hacks may be make load down in my forum

if anyone have any soulation to me please tell me

and if i want to convert to phpbb3 this days does

phpBB-SEO-Simple-mod-Rewrite

Optimal_titlesV_1.0.0

gym_sitemaps

is ready or no

really i wont to go to vb

[dcz]

You can empty the sessions and sessions keys tables, it will just reset the auto log-in keys and will drop all of your user sessions.

You user will just have to re log-in after the clear up, and to re select auto log-in in case they had.

Now, we're a bit off topic talking about phpBB2.

You can try two things though, installing the phpBBstyles.com SQL cache mod can help out : http://www.phpbbstyles.com/viewtopic.php?t=8873

And once phpBB.com will be up again, I suggest you start reading the tweak for large forum thread : http://www.phpbb.com/phpBB/viewtopic.php?t=135383

One simple and efficient one is for if you do only use one style : http://www.phpbb.com/phpBB/viewtopic.php?p=2127995#2127995

This post from drathbun, among others, is a good one : http://www.phpbb.com/phpBB/viewtopic.php?p=2005778#2005778

++

[HB]

[mhmdkhamis]

[mhmdkhamis]

thank u HB for your replay and good ideas

[HB]

Sorry, I don't have a prepackaged mod to give you. Why don't you modify your own implementation? Modify your SQL call based on a test of $userdata['session_logged_in'], then modify your template:

[mhmdkhamis]

thabk u HB i install cash mod for doode and wait today to see

[mhmdkhamis]

i install Who is online time edit

does it effect im my forum load & make it less more

[lavinya]

mhmdkhamis

gzip setting set to "on" open.

and check .htaccess codes.

[mhmdkhamis]

[dcz]

By the way, looking at phpBB3 page loading time :