[Done 1.4.x & 1.3.x] Speedup your Boardindex NEW Version 2!

[Compuart]

checkout the fromName. It's case sensitive  

[Daniel D.]

 

Ok, ok, you're the king.

[groundup]

also:
it should store the member id instead of the member name for the logs. Also, when deleting a member, it deletes the IM's by username, which should be by the id. I am looking at that function right now so this is why I am bringing this up. I am sure there are other places wehre it does the same.

[Overseer]

just updated my board. didnt have any probs with boardmod this time. dropped in like a charm.
very noticeable performance jump! props!

[jthorpe]

My BoardIndex was painfully slow, even after this mod was installed.  I finally figured out the problem with mine and took that part of it out, and now my BoardIndex is instant!  There is a query in recent.php that is used to show the last post and gives a link to the 10 most recent posts on the boards.  Basically, I removed the pointer to this in the BoardIndex and it was 20 times faster than before.  Instead of showing the latest post on the BI, I just put a link to click on for the last 10 posts.  That's not a major issue for me.  The query that was giving me huge problems is listed below.  I believe it's the first query in recent.php:

Code Select Expand

# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 310947
SELECT m.posterTime,m.subject,m.ID_TOPIC,t.ID_BOARD,m.posterName,t.numReplies,t.ID_FIRST_MSG FROM dodgediesel_messages as m,dodgediesel_topics as t,dodgediesel_boards as b,dodgediesel_categories as c WHERE (m.ID_TOPIC=t.ID_TOPIC && t.ID_BOARD=b.ID_BOARD && b.ID_CAT=c.ID_CAT && (FIND_IN_SET('Administrator',c.memberGroups)!=0 || c.memberGroups='' || 'Administrator' LIKE 'Administrator' || 'Administrator' LIKE 'Global Moderator')) ORDER BY m.posterTime DESC LIMIT 1;

Check out my  board Index now:

http://www.dieseltruckresource.com/yabbse/index.php

[Compuart]

My BoardIndex was painfully slow, even after this mod was installed.  I finally figured out the problem with mine and took that part of it out, and now my BoardIndex is instant!  There is a query in recent.php that is used to show the last post and gives a link to the 10 most recent posts on the boards.  Basically, I removed the pointer to this in the BoardIndex and it was 20 times faster than before.  Instead of showing the latest post on the BI, I just put a link to click on for the last 10 posts.  That's not a major issue for me.  The query that was giving me huge problems is listed below.  I believe it's the first query in recent.php:

Yep, recent.php is slowing the forum down a great deal. But I guess you haven't tested out my second version of the speedup mod, cuz that one fixes the recent.php issue  

Thanks for pointing us in this direction though  

[jthorpe]

ahhh.  I guess I should test the second version.  

[lordy123]

OK, probably a stupid question, but where can I get the mod on its own? The links on the first post seem to be for complete YaBB SE distributions? I have a 1.4.1 install with all the bugs manually fixed and I'd now like to apply this mod manually..
Thanx!

[Spazer]

http://www.kyrandia.nl/test/SpeedUpBoardIndex-2.3.zip

You must have missed it...

[lordy123]

Thanx  

BTW, will this also help to reduce number of active connections?

[lbyard]

Super fast!!!  Installed without a glitch on 1.4.1 using BoardMod.  Larry
http://duxcw.com/yabbse

[strike2death]

hi, i installed the latest version and i get this error:

2: Supplied argument is not a valid MySQL result resource
(/data/members/free/multimania/fr/t/h/e/themartos/htdocs/yabbse/Sources/BoardIndex.php ln 167)

so now im gonna uninstall it until i can fix it

[strike2death]

this mod really works, but the error that i said before is just in the index

[Compuart]

you didn't forget to run the php that was in the zip?

[groundup]

Just to make sure everyone knows this.. this mod is present in 1.5. If you wish to install this mod, I recommend just upgrading to 1.5 as there are even more fixes.