• Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 1,238

Topic: PunBB 1.3 experemental branch

Not too long ago we found some inefficient SQL queries in PunBB 1.3. A big amount of computer resources was required to execute some queries on big databases. So we decided to create a new svn branch with optimized queries. When all our changes will be justified, we will apply it to the PunBB 1.3 core. It will be great if you help us test these changes, and compare the performance with that of the main PunBB 1.3 branch.

SVN link

Slavok's Website

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: PunBB 1.3 experemental branch

Thanks Slavok

On a sidenote
Just installed the above experimental svn and then installed some exts to test
1.
Notice: Undefined index: post_karma in /.../viewtopic.php(325) : eval()'d code on line 10
Notice: Undefined index: user_karma in /..../viewtopic.php(486) : eval()'d code on line 10

... I get the above error at the moment .... If I disable post_karma ext all works as it should...
(PS: as I don't have large database to test on, I can't give any hard data on speed...)

2.
Edit: The username doesn't seem to be showing ... just blank space, then Administrator...

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: PunBB 1.3 experemental branch

RE: 2.  Ext related issue aswell
Colored usergroups - if I disable that the usernames show again....

  • Registered: 2007-08-08
  • Posts: 12

Re: PunBB 1.3 experemental branch

Slavok, there is a mistake in r1510. The second query runs twice.

Can you explain why you think the new queries (especially the one in r1511) will run faster? Do you have any SQL documentation that suggests such an approach?

5 Reply by zklee

  • zklee
  • New Member
  • Offline
  • Registered: 2010-03-27
  • Posts: 1

Re: PunBB 1.3 experemental branch

big_smile Good,Thank you!

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: PunBB 1.3 experemental branch

Any news here?

FluxBB team rewrite SQL-query for retriving posts in viewtopic.php and got 10x faster on big topics.
I ported his idea to my ext http://punbb.ru/post28307.html#p28307 and it work good, except with ext that change post order in query. But i think one hook may help.

May be we should integrate this imporvents in core and release in 1.3.5? Yes, it break some very small part ext, but results will be good.

I known Slavok tested some things in 1.3-exp branches.

  • Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 1,238

Re: PunBB 1.3 experemental branch

This changes will be added, but not in 1.3.5. The 1.3.5 version will contain bug fixes and some minor features.

Slavok's Website