Author Topic: Make the site faster  (Read 2591 times)

0 Members and 1 Guest are viewing this topic.

Offline ThePro

  • Hero Member
  • ******
  • Posts: 2405
Make the site faster
« on: May 24, 2011, 06:15 »
I have been feeling that since a few months ago the server has gotten slower and slower, on most posts it says Page Created in 1+ seconds

And if I load an image it only does 30KB/s

Also, could you upload this file to the server so I can double check the download speed? http://sftp.fibertel.com.ar/services/32mb.zip


EDIT: I meant images hosted on TMS, also, this topic gave me this

Page created in 0.907 seconds with 19 queries.

almost 1 second :P

EDIT2:

A video showing the slowness

http://tinypic.com/r/2z53n6c/7
« Last Edit: May 24, 2011, 06:26 by ThePro »

Offline Rafay

  • VIP
  • Hero Member
  • *
  • Posts: 2106
  • var nerd; nerd = db_getUser("rafay");
Re: Make the site faster
« Reply #1 on: May 24, 2011, 06:27 »
I think it's just fine as it always has been.

Offline ThePro

  • Hero Member
  • ******
  • Posts: 2405
Re: Make the site faster
« Reply #2 on: May 24, 2011, 06:27 »
I think it's just fine as it always has been.

That's cause you have pakistani internet :P

Offline Panki

  • VIP
  • Ultimate Member
  • *
  • Posts: 12576
  • 0x1A4 every day
Re: Make the site faster
« Reply #3 on: May 24, 2011, 06:37 »
Page created in 0.077 seconds with 20 queries.

It's your connections fault, not much we can do about that.

"QOTD: You know you've drunk too much when you actually ask the wife to drive you home. "

LMAO!

Offline ThePro

  • Hero Member
  • ******
  • Posts: 2405
Re: Make the site faster
« Reply #4 on: May 24, 2011, 06:59 »
Page created in 0.077 seconds with 20 queries.

It's your connections fault, not much we can do about that.

I don't really think it's that, as the Page Created in X seconds is from inside the server

And, I can download fine from sites with higher pings then this

Here's a tracert (dunno if it matters):

Code: [Select]
Traza a la dirección forums.themavesite.com [208.43.136.60]
sobre un máximo de 30 saltos:

  1     1 ms     1 ms     1 ms  192.168.1.1
  2    13 ms    23 ms    49 ms  1-203-194-190.cab.prima.net.ar [190.194.203.1]
  3     *        *        *     Tiempo de espera agotado para esta solicitud.
  4     *        *        *     Tiempo de espera agotado para esta solicitud.
  5     *        *        *     Tiempo de espera agotado para esta solicitud.
  6    13 ms    28 ms    12 ms  21-165-89-200.fibertel.com.ar [200.89.165.21]
  7    13 ms    14 ms    11 ms  250-165-89-200.fibertel.com.ar [200.89.165.250]

  8    13 ms    15 ms    15 ms  200-63-151-33.speedy.com.ar [200.63.151.33]
  9   208 ms   188 ms   193 ms  So3-0-0-0-grtbueba2.red.telefonica-wholesale.net
 [84.16.6.1]
 10   183 ms   183 ms   186 ms  So3-0-0-0-grtbueba2.red.telefonica-wholesale.net
 [84.16.6.1]
 11   181 ms   185 ms   185 ms  Xe4-1-3-0-grtmiabr7.red.telefonica-wholesale.net
.125.142.94.in-addr.arpa [94.142.125.118]
 12   265 ms   178 ms   323 ms  Xe5-0-1-0-grtmiana2.red.telefonica-wholesale.net
.122.142.94.in-addr.arpa [94.142.122.249]
 13   143 ms   150 ms   149 ms  softlayer-AE-0-0-grtmiana2.red.telefonica-wholes
ale.net [213.140.51.190]
 14   146 ms   156 ms   149 ms  po1.bbr02.tm01.mia01.networklayer.com [173.192.1
8.175]
 15   172 ms   175 ms   178 ms  ae3.bbr01.sr02.hou02.networklayer.com [173.192.1
8.162]
 16   263 ms   263 ms   263 ms  ae3.bbr01.eq01.dal03.networklayer.com [173.192.1
8.218]
 17   186 ms   181 ms   176 ms  ae7.bbr02.eq01.dal03.networklayer.com [173.192.1
8.209]
 18   279 ms   291 ms   283 ms  po2.bbr02.cf01.den01.networklayer.com [173.192.1
8.139]
 19   209 ms   213 ms   210 ms  po4.bbr01.wb01.sea01.networklayer.com [173.192.1
8.144]
 20   206 ms   207 ms   207 ms  po2.cer01.sr01.sea01.networklayer.com [173.192.1
8.199]
 21   210 ms   210 ms   207 ms  po1.fcr01.sr01.sea01.networklayer.com [67.228.11
8.134]
 22   212 ms   210 ms   206 ms  hostupon.com [208.43.136.60]

And to my site:

Code: [Select]
Traza a la dirección theproweb.net [216.66.76.38]
sobre un máximo de 30 saltos:

  1     1 ms     1 ms     1 ms  192.168.1.1
  2    15 ms    14 ms    16 ms  1-203-194-190.cab.prima.net.ar [190.194.203.1]
  3     *        *        *     Tiempo de espera agotado para esta solicitud.
  4     *        *        *     Tiempo de espera agotado para esta solicitud.
  5     *        *        *     Tiempo de espera agotado para esta solicitud.
  6    14 ms    11 ms    12 ms  21-165-89-200.fibertel.com.ar [200.89.165.21]
  7    12 ms    12 ms    12 ms  250-165-89-200.fibertel.com.ar [200.89.165.250]

  8    34 ms    13 ms    12 ms  200-63-151-33.speedy.com.ar [200.63.151.33]
  9   192 ms   199 ms   197 ms  84.16.6.61
 10   190 ms   192 ms   197 ms  84.16.6.61
 11   267 ms   183 ms   191 ms  So3-1-3-grtmiabr8.red.telefonica-wholesale.net.1
25.142.94.in-addr.arpa [94.142.125.138]
 12   186 ms   181 ms   195 ms  Xe2-3-0-0-grtnycpt3.red.telefonica-wholesale.net
 [84.16.15.129]
 13   189 ms   162 ms   191 ms  gige-g2-4.core1.nyc5.he.net [216.66.41.213]
 14   208 ms   179 ms   179 ms  v110.core1.nyc4.he.net [184.105.213.69]
 15   218 ms   219 ms   200 ms  10gigabitethernet8-3.core1.chi1.he.net [72.52.92
.178]
 16   233 ms   243 ms   227 ms  10gigabitethernet1-1.core1.mci1.he.net [72.52.92
.2]
 17   205 ms   191 ms   194 ms  10gigabitethernet2-2.core1.mci3.he.net [184.105.
213.34]
 18   197 ms   191 ms   210 ms  216.66.73.130
 19   199 ms   193 ms   195 ms  216.66.76.251
 20   196 ms   194 ms   214 ms  216.66.76.38

My site always maxes out my connection.

Offline Mave

  • TMS Founder
  • Administrator
  • Godfather
  • *********
  • Posts: 122745
Re: Make the site faster
« Reply #5 on: May 24, 2011, 07:37 »
TMS is still loading the same for me as it did 3 years ago.

Offline ThePro

  • Hero Member
  • ******
  • Posts: 2405
Re: Make the site faster
« Reply #6 on: May 24, 2011, 07:58 »
It just feels slower for me :/

Offline GPow69

  • consololol ಠ_ಠ
  • Global Moderator
  • Ultimate Member
  • ********
  • Posts: 18872
  • EDM for life ♥
Re: Make the site faster
« Reply #7 on: May 24, 2011, 08:03 »
TMS is still loading the same for me as it did 3 years ago.

Slower for me too it seems..

Offline Impulse

  • Global Moderator
  • Master Member
  • ********
  • Posts: 7849
  • LozL
Re: Make the site faster
« Reply #8 on: May 24, 2011, 08:36 »
What I have is that it is fast most of the times, but sometimes it's just damn slow for a couple of hours. Don't know if that is me or not.

Offline Andre

  • VIP
  • Pro Member
  • *
  • Posts: 2511
Re: Make the site faster
« Reply #9 on: May 25, 2011, 12:42 »
I don't really think it's that, as the Page Created in X seconds is from inside the server
That's correct. The page creation time is calculated by SMF and it means how long it takes PHP to fetch the page for you. I also checked some parts of the forums and got load times from 0.350 to 0.550 seconds usually (and some exceptions of 1.6 seconds from Post your desktop topic for example). That's definitely a sign of some serious server overloading, but there's no-one to blame except for cheap hosting providers who drive the price down constantly and thereby make customers suffer. Although I assume one must be ready for some problems and speed issues when they're paying only like $10 a month and hosting a huge site on it.

I have access to a few forums which run on their own dedicated server boxes together with either SA-MP, MTA or Minecraft servers running by side. But for a quick comparison I checked the usual loading speed from SF-SE.
my forum's largest topic (59000+ replies): Page created in 0.038 seconds with 20 queries.
TMS' largest topic (4100+ replies): Page created in 0.85 seconds with 18 queries.
TMS loading is 22 times slower.

There would be a few things to do:
1. enable cache (I'd recommend APC). The results won't often show in regular topics because I doubt any of the post content is cached. But memstorage is much much faster than loading from databases or files. Although this may not be possible with this host...
2. optimize tables (and run the regular maintenance on logs and shit in the admin section)
3. remove very old/useless "unread topic" entries for members who haven't been online for a long time. I assume there are hundreds of thousands if not millions of useless entries like that in TMS' database.
4. get a new hosting provider, a more powerful server

I doubt the connection of the site datacentre or anyone's home line would be questioned if the PHP times are as slow as they are. I suppose the forum is stuck on a crowded dedi box with another shitload of sites running on it and your hoster is probably making hell of a profit at the moment.

Offline Mave

  • TMS Founder
  • Administrator
  • Godfather
  • *********
  • Posts: 122745
Re: Make the site faster
« Reply #10 on: May 25, 2011, 02:12 »
Well, I normally optimize all tables every few days, but it took a while now.

Quote
Your database contains 78 tables.
Attempting to optimize your database...
Optimizing smf_admin_info_files... 10.28 kb optimized.
Optimizing smf_log_actions... 0.23 kb optimized.
Optimizing smf_log_errors... 1.86 kb optimized.
Optimizing smf_log_floodcontrol... 0.07 kb optimized.
Optimizing smf_log_online... 4.86 kb optimized.
Optimizing smf_log_scheduled_tasks... 1.20 kb optimized.
Optimizing smf_log_search_results... 0.11 kb optimized.
Optimizing smf_log_topics... 1.30 kb optimized.
Optimizing smf_sessions... 233.83 kb optimized.

9 table(s) optimized.

I also empty out the unimportant logs from time to time.

1 -> Not possible on this server/
2 -> Already exlpained above
3 -> If you could assist me with that I could do it.
4 -> I don't have money for a new host (also note that this host has been paid until December 2012)

Offline Panki

  • VIP
  • Ultimate Member
  • *
  • Posts: 12576
  • 0x1A4 every day
Re: Make the site faster
« Reply #11 on: May 25, 2011, 06:32 »
^ We won't be needing one after that time :troll:

Offline Andre

  • VIP
  • Pro Member
  • *
  • Posts: 2511
Re: Make the site faster
« Reply #12 on: May 25, 2011, 07:37 »
lold Panki :laugh:

Mave here's an useful topic...

Offline MiRc34

  • Ultimate Member
  • *********
  • Posts: 11274
  • #3 Top Poster Hurr Durr.
Re: Make the site faster
« Reply #13 on: May 25, 2011, 07:39 »
I was about to post something like you, panki, but I couldn't bust ass to find the right words..

But yeah, TMS is epicly fast sometimes, but sometimes damn slow D:

Offline Panki

  • VIP
  • Ultimate Member
  • *
  • Posts: 12576
  • 0x1A4 every day
Re: Make the site faster
« Reply #14 on: May 25, 2011, 07:43 »
I just had a phase where it took 12 seconds to create the page. But suddenly, they load all at once.

[FF]TeddyBear

  • Guest
Re: Make the site faster
« Reply #15 on: May 26, 2011, 07:50 »
Yes sometimes, usually in the mornings here, for about 10 minutes tms will take a bit to load  :huh:

Online Mauri

  • (`・ω・´)
  • Global Moderator
  • Master Member
  • ********
  • Posts: 6334
  • Of course, my horse
Re: Make the site faster
« Reply #16 on: May 26, 2011, 10:15 »
TMS is very rarely slow for me, so that doesn't bother me at all. ::3:

...

Or actually, it does. I die a bit inside when I can't browse TMS. Damn you Mave for making me addicted to this site. ;__;
« Last Edit: May 26, 2011, 10:17 by Mauri »

Offline Mave

  • TMS Founder
  • Administrator
  • Godfather
  • *********
  • Posts: 122745
Re: Make the site faster
« Reply #17 on: May 26, 2011, 07:37 »
lold Panki :laugh:

Mave here's an useful topic...

Thanks for that link Andre, bookmarked, I will make sure that TMS will be optimized as much as possible.

Offline ThePro

  • Hero Member
  • ******
  • Posts: 2405
Re: Make the site faster
« Reply #18 on: August 15, 2011, 07:11 »
BUMP.

I just noticed that search is damm slow..

What can we do to fix it?

5: If you are going to enable search, and are not or cannot use Sphinx, use a Large Custom Index. SMF's custom index works by taking a hash of every available word, and then building an index of which words point to which messages. 'Small' means this is a 16 bit hash, 'Moderate' is 24 and 'Large' is a 32 bit hash. 'Large' is thus only two bytes larger per record than small is, plus an additional number of records based on the average number of unique words per post you have - which is not going to be a significant increase. The speed improvement you get for the additional ~40% space usage is well worth it.

Offline Panki

  • VIP
  • Ultimate Member
  • *
  • Posts: 12576
  • 0x1A4 every day
Re: Make the site faster
« Reply #19 on: August 15, 2011, 07:15 »
SMFs search is bullshit. It doesn't find threads even if you enter the exact title...