forum.coppermine-gallery.net

No Support => General discussion (no support!) => Topic started by: OmegaGOD on May 18, 2005, 10:22:53 pm

Title: Board is slow
Post by: OmegaGOD on May 18, 2005, 10:22:53 pm
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.
Title: Re: Board is slow
Post by: donnoman on May 18, 2005, 11:23:39 pm
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.
Title: Re: Board is slow
Post by: kegobeer on May 18, 2005, 11:25:52 pm
Plenty of known issues at Sourceforge:

http://sourceforge.net/docman/display_doc.php?group_id=1&docid=2352
Title: Re: Board is slow
Post by: OmegaGOD on May 19, 2005, 01:12:44 am
Thanks Donnoman and Kegobeer. Good to know it's being addressed.  :)
Title: Re: Board is slow
Post by: Joachim Müller on May 19, 2005, 08:42:00 am
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.
Title: Re: Board is slow
Post by: betan on May 20, 2005, 12:10:47 am
whew good to know  ;D all along i thought it was the -3 karma thing on my profile equate to .03 kbps browsing speed on this board.  :D 
Title: Re: Board is slow
Post by: betan on June 08, 2005, 02:11:25 am
what happened it is loading like before now, a lot lot faster. :)
Title: Re: Board is slow
Post by: Tranz on June 08, 2005, 08:01:54 am
whew good to know ;D all along i thought it was the -3 karma thing on my profile equate to .03 kbps browsing speed on this board. :D
:D Interesting concept... correlating karma level to access speed. ;D
Title: Re: Board is slow
Post by: Joachim Müller on June 08, 2005, 10:02:17 am
this would be an award-winning mod for SMF, let's consider this (I'm serious).
Title: Re: Board is slow
Post by: hama on June 08, 2005, 11:53:10 am

@TranzNDance

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

Title: Re: Board is slow
Post by: Abbas Ali on June 09, 2005, 10:50:12 am
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]
call_user_func(smf_main());
Add

Code: [Select]
/**
 * 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.
Title: Re: Board is slow
Post by: hama on June 09, 2005, 11:39:38 am

Quote
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!


Title: Re: Board is slow
Post by: Tranz on June 09, 2005, 04:56:31 pm
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. :)
Title: Re: Board is slow
Post by: betan on June 10, 2005, 08:06:04 am
since im the one that made mod suggestion, can you guys remove at least 2 neg karma from mine? :)
Title: Re: Board is slow
Post by: Abbas Ali on June 10, 2005, 08:24:02 am
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. :)
Title: Re: Board is slow
Post by: Joachim Müller on June 13, 2005, 08:43:03 am
see We need your help (http://forum.coppermine-gallery.net/index.php?topic=14227.0)...