Welcome, Guest. Please Login or Register    
 
smk mk64 mksc mkdd mkds mkwii mk7 mk8
general   mafia   smk   mk64   mksc   mkdd   mkds   mkw   mk7   mk8   |   problems   |   discord   irc
 
  Home Search Members Login Register
 
Pages: 1
Send Topic Print
Actual Problem (Read 146 times)
Camster
Legend
*****
Offline

Forum Recluse

punched 7158 kiddies
CA
Gender: male
Actual Problem
04/05/11 at 13:31:43
 
I've noticed that viewing someone's profile takes a long time to load, whereas the rest of the site runs just fine. It's not a huge problem, but I figured it should be pointed out.

Alex forgetting to rebuild the indexes?
Back to top
 
 
View Profile enigmaticcam   IP Logged
Mick
Ninja
*****
Offline



6045 days karting
France
Gender: male
Re: Actual Problem
Reply #1 - 04/05/11 at 13:43:51
 
I have the same problem, but only with the ninjas'/mods' profiles, interestingly !
Back to top
 
 

Youtube (Mario Kart 8 WRs) - Twitter - Twitch

Camster wrote on 02/10/10 at 08:50:34:
A world without kart is just not a world worth living in

Web wrote on 05/13/10 at 11:24:04:
You can't quit kart, it's a mental impossibility.
View Profile   IP Logged
Camster
Legend
*****
Offline

Forum Recluse

punched 7158 kiddies
CA
Gender: male
Re: Actual Problem
Reply #2 - 04/05/11 at 13:57:30
 
Well looks like it's fixed. Ninjas at it again.  Smiley
Back to top
 
 
View Profile enigmaticcam   IP Logged
Fant0m
Myth
*****
Offline

aka Flo

ate 5942 donuts
Paris / France
Gender: male
Re: Actual Problem
Reply #3 - 04/05/11 at 13:58:45
 
This always happened to me so I never really payed attention to it...I just thought it was normal... but it still happens to me for any profile. Smiley

Edit: forgot to mention, especially when you click to see profiles from the "members" list...
Back to top
 
 
View Profile WWW flo1fullmetal   IP Logged
IsThatAGoodTime
NinjaThing
*****
Offline



helped 6760 people

Gender: male
Re: Actual Problem
Reply #4 - 04/05/11 at 14:24:11
 
When you load a user's profile, the site needs to find the last post you made.  Guess how well they implemented that.  I'll give you a hint: when the forum has more posts, it takes longer  :'(

I think we looked at it a little and determined if you have a recent post in every (even closed) board category, your profile will tend to load faster. Not sure if we ever checked into that though.
Back to top
 
 
View Profile   IP Logged
Camster
Legend
*****
Offline

Forum Recluse

punched 7158 kiddies
CA
Gender: male
Re: Actual Problem
Reply #5 - 04/05/11 at 14:41:07
 
I don't know the exact structure of the database, but what if you put a reverse index on the unique id of each post?
Back to top
 
 
View Profile enigmaticcam   IP Logged
IsThatAGoodTime
NinjaThing
*****
Offline



6760 days karting

Gender: male
Re: Actual Problem
Reply #6 - 04/05/11 at 14:58:34
 
There's no database  Smiley, <3, etc etc
Back to top
 
 
View Profile   IP Logged
Camster
Legend
*****
Offline

Forum Recluse

7158 days karting
CA
Gender: male
Re: Actual Problem
Reply #7 - 04/05/11 at 15:03:59
 
Posts aren't stored in a database? How are they stored?
Back to top
 
 
View Profile enigmaticcam   IP Logged
IsThatAGoodTime
NinjaThing
*****
Offline



helped 6760 people

Gender: male
Re: Actual Problem
Reply #8 - 04/05/11 at 15:11:07
 
Like this:

Code:
Werewolf Game Thread - Game Over Town Win!|The Gaff|thomasgx1@yahoo.co.uk|1291575705|thomasgx1|wink|0||Hello to you all. I will update this topic tomorrow when the game begins. While I have a moment here is the final selection<br /><br />In no particularly order<br />1. [s]Zwiebel[/s]<br />2. [s]Ivootjes[/s]<br />3. Zarkov<br />5. [s]Brett[/s]<br />6. Moon man<br />7. Cutz22<br />8. thewebinator<br />9. [s]Honko[/s]<br />10. [s]padz[/s]<br />11. Shock<br />12. RVZ<br />13. Thiradell<br /><br />There are 3 Mafia, 1 Scanner and 1 Doctor. I shall reveal 'town' or 'mafia' when kills take place but not roles. You should all have your roles by now  ;)||1292589546|thomasgx1| 



In text files. One file per topic, one line per post.  A+ for effort but a bit behind the times. YaBB is still in Perl+txt files, some people changed it to PHP+MySQL and call that SMF now.

Anyway I tied shadow's wrists to his keyboard for 10 minutes so we could remove the time consuming part of loading profiles.
Back to top
 
 
View Profile   IP Logged
Camster
Legend
*****
Offline

Forum Recluse

7158 days karting
CA
Gender: male
Re: Actual Problem
Reply #9 - 04/05/11 at 15:17:17
 
Wow. Is that standard for most forums? Text files seem so...archaic. Good to know though, thanks for the info Smiley

I think you got IP addresses in that script though...
Back to top
 
 
View Profile enigmaticcam   IP Logged
IsThatAGoodTime
NinjaThing
*****
Offline



6760 days karting

Gender: male
Re: Actual Problem
Reply #10 - 04/05/11 at 15:21:31
 
Most modern forums use db of course.  At least this way the forums don't go down every time the kart sites do  Grin Then who would be able to whine.


Just Tom's IP, sure he won't come crying!
Back to top
 
 
View Profile   IP Logged
Fant0m
Myth
*****
Offline

aka Flo

5942 days karting
Paris / France
Gender: male
Re: Actual Problem
Reply #11 - 04/06/11 at 10:53:30
 
Lol ok. Smiley
That's a way to do. ^^
Back to top
 
 
View Profile WWW flo1fullmetal   IP Logged
Pages: 1
Send Topic Print