Board is slow

[OmegaGOD]

Has anyone else noticed that the support board has been a bit sluggish? I've had horrible page load times with the worst being 68 seconds. It's been on and off for the past 2 weeks.

Page created in 9.939 seconds with 12 queries.
Page created in 33.106 seconds with 18 queries.
Page created in 10.695 seconds with 12 queries.

[donnoman]

Yes, the dev's have seen the same thing and are discussing it in the dev forums.

It's not just coppermine however its a sourceforge thing, I've been on other projects and experienced it as well.

We've been talking about moving the boards to another server, Joachim is trying to work out the logistics. He will post when he's ready to make the change.

In the meantime if SF.net fixes whatever is going on, then we will be back to normal.

[kegobeer]

Plenty of known issues at Sourceforge:

http://sourceforge.net/docman/display_doc.php?group_id=1&docid=2352

[OmegaGOD]

Thanks Donnoman and Kegobeer. Good to know it's being addressed. 

[Joachim Müller]

As already mentioned above, we're planning to move the board and the coppermine demo to another server. The problem is that this has to be done in one single effort - during the move, the board will be down for maintenance. I'm not sure how long the move will take, but clearly several hours. I have to figure out a schedule when to do this. Probably the move will be next week on thursday (which is a holiday in Germany, so I'll have the whole day to do whatever is needed). The maintenance (and resulting downtime) will be announced.

[betan]

whew good to know  all along i thought it was the -3 karma thing on my profile equate to .03 kbps browsing speed on this board.   

[betan]

what happened it is loading like before now, a lot lot faster.

[Tranz]

whew good to know all along i thought it was the -3 karma thing on my profile equate to .03 kbps browsing speed on this board.

Interesting concept... correlating karma level to access speed.

[Joachim Müller]

this would be an award-winning mod for SMF, let's consider this (I'm serious).

[hama]

@TranzNDance

Ok, let's stay together ... I give you a +1 and so do I ...  

[Abbas Ali]

As GauGau was serious about the mod, i though why not give it a try and came up with a very simple mod.

This might not be the best but is working and can be optimized. Tested with smf 1.0.2.

Edit index.php

Just after

Code Select Expand

call_user_func(smf_main());

Add

Code Select Expand


/**
* Code to delay the execution of script depending on the karma of the user
* The execution gets delayed only if the karma is negative.
* The script is delayed by seconds equal to double the absolute value of karma.
*
* loadMemberData() could have been used which returns the member data in $user_profile array. But the query fired in that function is too heavy.
* Hence for simplicity a query which just gets the karma is fired below.
*/
$query = "SELECT karmaGood, karmaBad FROM {$db_prefix}members WHERE ID_MEMBER = '$ID_MEMBER'";
$request = db_query($query, __FILE__, __LINE__);

if (mysql_num_rows($request)) {
  $row = mysql_fetch_array($request);
  $karma = $row['karmaGood'] - $row['karmaBad'];
    if ($karma < 0) {
      $sleep = abs($karma)*2;
      sleep($sleep);
    }         
}


For now this works only for negative karma. Logic can be improved.

this would be an award-winning mod for SMF, let's consider this (I'm serious).

Will be waiting for the award 

P.S: It was Aditya's idea to use sleep() function.

[hama]

Will be waiting for the award  

I can't give you an award (I only can give you positive karma   ) but I just want to say that the world of PHP is really crazy ... Every little problem can be solved with a short PHP-Mod.

I'm not sure if this solution works in real "forum life". What about people giving negative karma to someone else just as a bad joke?

But the mod for itself is great!

[Tranz]

Well, if someone gives out negative karma as a bad joke, that person could be easily punished by plenty of other folks with negative karma. But this would require knowing who gave out the negative karma. :-\\

Great job, Abbas Ali.

[betan]

since im the one that made mod suggestion, can you guys remove at least 2 neg karma from mine?

[Abbas Ali]

Don't worry, this mod has not been implemented on this support board as yet. But who knows in future it might be implemented since nowadays there are lots of people who just want to shout at us and deliberately tease us with some useless questions. They don't read manaul, don't follow our instructions etc ... By doing this they get negative karma and this mod may be useful in such cases.

P.S: The better way of increasing your karma is by helping other people and contributing to the board.

[Joachim Müller]

see We need your help...