The speed increase is astounding

Discuss features as they are added to the new version. Give us your feedback. Don't post bug reports, feature requests, support questions or suggestions here.
Forum rules
Discuss features as they are added to the new version. Give us your feedback. Don't post bug reports, feature requests, support questions or suggestions here. Feature requests are closed.
Post Reply
Amailer
Registered User
Posts: 16
Joined: Sun Mar 28, 2004 5:52 am
Location: www.AaronDM.com
Contact:

Re: The speed increase is astounding

Post by Amailer » Mon Jan 29, 2007 3:14 am

I'm sorry if it has been answered already - but WOW what the heck changes did you guys do to improve the speeds so DAMN much? PLEASE TELL >> I wanna mod my phpBB2 :P

User avatar
NNO-Stephen
Registered User
Posts: 398
Joined: Fri May 23, 2003 12:47 am
Location: Tulsa, Oklahoma
Contact:

Re: The speed increase is astounding

Post by NNO-Stephen » Mon Jan 29, 2007 12:26 pm

heh, there will be no mod for phpBB2 to make it this fast :lol:

just upgrade.
Image

Amailer
Registered User
Posts: 16
Joined: Sun Mar 28, 2004 5:52 am
Location: www.AaronDM.com
Contact:

Re: The speed increase is astounding

Post by Amailer » Mon Jan 29, 2007 7:38 pm

I could try and make one >> What exactally was the change?

NeoThermic
Registered User
Posts: 198
Joined: Fri Jan 02, 2004 3:44 pm
Location: United Kingdom
Contact:

Re: The speed increase is astounding

Post by NeoThermic » Mon Jan 29, 2007 8:59 pm

Amailer wrote: I could try and make one >> What exactally was the change?



Uhh, a total rewrite? phpBB 2.0 and phpBB 3 do not share any code *. It would be difficult to mod 2.0 to be as fast as 3.0 without bordering on a total rewrite of 2.0, which would defeat the point :)

NeoThermic

* Ok, they do, but I'm referring to parts where code was not back/forward ported between the two.
phpBB release date pool!
The NeoThermic.com... a well of information. Ask me for the bit bucket so you can drink its goodness. ||新熱です

Amailer
Registered User
Posts: 16
Joined: Sun Mar 28, 2004 5:52 am
Location: www.AaronDM.com
Contact:

Re: The speed increase is astounding

Post by Amailer » Mon Jan 29, 2007 10:31 pm

Oh not a total rewrite - but the noticable speeds showed up in Beta 5 only - so unless you guys did some major changes in the code (then forget it) or added some crazy sql cacheting or something - what was it? XD

Only reason I dont feel like switching over is because - well I spent so much time on modding phpBB2, it all feels like a waste :(

code reader
Registered User
Posts: 653
Joined: Wed Sep 21, 2005 3:01 pm

Re: The speed increase is astounding

Post by code reader » Mon Jan 29, 2007 11:00 pm

Cap'n Refsmmat wrote: SQL caching will almost certainly be a huge win when someone hooks it up to memcached or a PHP accelerator's shared memory cache (most offer one).

"almost certainly" is not a very good benchmark.
i doubt your statement is based on any real data, but in the case i am wrong, i would like very much to hear from you, or anyone else who did some actual measurements with sql caching on/off, and can report the results.

personally, if i had to wager, i would bet that in most cases turning off sql caching will improve performance.
the problem is that there is no simple way to turn sql cache off and on, so if one wants to experiment, one has to cripple the code that handles the sql caching. not many will do that, with the result that no serious experimentation is likely to happen.
not a huge deal, but a pity nonetheless.

Cap'n Refsmmat
Registered User
Posts: 219
Joined: Tue Jan 25, 2005 11:31 pm

Re: The speed increase is astounding

Post by Cap'n Refsmmat » Tue Jan 30, 2007 12:18 am

code reader wrote: "almost certainly" is not a very good benchmark.
i doubt your statement is based on any real data, but in the case i am wrong, i would like very much to hear from you, or anyone else who did some actual measurements with sql caching on/off, and can report the results.

personally, if i had to wager, i would bet that in most cases turning off sql caching will improve performance.
the problem is that there is no simple way to turn sql cache off and on, so if one wants to experiment, one has to cripple the code that handles the sql caching. not many will do that, with the result that no serious experimentation is likely to happen.
not a huge deal, but a pity nonetheless.

The reason you believe turning it off will improve performance is because it is currently file-based, meaning that there's a file access overhead. The speed increase there depends on the disk speed of the server.

However, the acm is modular, so if you were to add in a memcached backend (memcached is memory-based and can be distributed over multiple servers), you'd almost certainly get a performance win. I have not written such a backend yet, but I use memcached in a vBulletin install, and it certainly helps.

User avatar
Acyd Burn
Posts: 1838
Joined: Tue Oct 08, 2002 5:18 pm
Location: Behind You
Contact:

Re: The speed increase is astounding

Post by Acyd Burn » Tue Jan 30, 2007 9:47 am

We already have a memcached version in the works and of course it is faster due to the file i/o not being accessed. Turning off sql caching may increase the performance for some if special conditions are met, but overall it should increase the performance if turned on, especially for mid-sized to large boards. For tiny boards the difference is not noticeable anyway.

What we found out is that, compared to 2.0.x, the cpu load decreased and the file i/o increased (of course) noticeably. But this was to be expected.

Image

Spectral Dragon
Registered User
Posts: 208
Joined: Mon Feb 16, 2004 1:45 pm
Location: Milan, MI
Contact:

Re: The speed increase is astounding

Post by Spectral Dragon » Tue Jan 30, 2007 12:35 pm

Amailer wrote: but the noticable speeds showed up in Beta 5 only


Actually people have been noticing the speed difference since before beta even came out.... so I don't believe this is correct.

code reader
Registered User
Posts: 653
Joined: Wed Sep 21, 2005 3:01 pm

Re: The speed increase is astounding

Post by code reader » Tue Jan 30, 2007 1:31 pm

Acyd Burn wrote: ....
Turning off sql caching may increase the performance for some if special conditions are met, but overall it should increase the performance if turned on, especially for mid-sized to large boards.
you may be right here, but then again, you may also be wrong.
the only reliable way to find out is to turn sql caching on and off and compare performance.
there are many variables, besides the size of the board. specifically, what backend db system is used? how much memory is available on the server? etc. etc.
in time, some "street wisdom" may develop. maybe sql caching boosts performance with mssql, but with mysql 5.x with query-caching turned on it is actually a hindrance?
without a simple and easy way to turn sql caching off and on, these questions will remain in the religious realm, as in "i believe sql caching boosts performance" and "i believe sql caching does nothing for performance".

of course, if anyone had actually done any measurements, i will be grateful to hear about it.

Post Reply