Resolved Page load times

  • HTML tutorial
slomatt

slomatt

Rank V

Influencer I

1,723
Bay Area, CA
OverlandBound.com consistently has by far the slowest page load speeds of any forum I visit. According to the stats in the footer the average thread listing takes ~5s to render and requires 8-10k database queries. This is an absolutely crazy number of queries to render a single page. I'm assuming the bottle neck is database performance and not processor or memory usage by PHP.

I'm not trying to be critical, but I am wondering if Xenforo has any optimizations that could help to reduce the number of database connections? Is caching an option?

For example, the "New Posts" page shows 20 results and the footer indicates that it requires ~9k queries to render. Is that metric accurate? If so, that works out to roughly 450 queries per result (minus a few for the "chrome" in the header and right bar of the page). I work on enterprise level web applications for a living and this amount of db queries for a single page is well over an order of magnitude more than I would expect.

Just curious...
 
  • Like
Reactions: MazeVX, Aaron Niemi, Graeman and 1 other person
nickburt

nickburt

Rank VII
Launch Member

Creator III

5,613
Wallasey, Wirral. UK
First Name
Nick
Last Name
Burt
Member #

2714

Agree with it being the slowest ever to load. Especially pages where there's lots of hi res photos - some of those can take several tens of seconds to load.
 
  • Like
Reactions: Graeman
slomatt

slomatt

Rank V

Influencer I

1,723
Bay Area, CA
nomad666 said:
faster than snot for me it all depends on the servers it has to go through before it gets to you if a slow one is in between here and you well it then sucks to be you...
Click to expand...
The "timing" value in the footer is rendering time on the server. Network latency is an entirely different issue.
 
Craig M

Craig M

Rank VI
Launch Member

Advocate III

3,921
Haslet, Texas, USA
First Name
Craig
Last Name
M
Member #

5444

I came to this sub forum to post a thread about this too.. It's always been slow for me here, but seems to be getting worse.. Like so much so that I rarely spend much time before I get frustrated and leave.

I just timed a few things (loading 'watched threads', 'pew posts', and clicked on a few different forums) and the fastest page to load was over 6 seconds, the longest over 11 seconds.

There are 3 other forums I visit regularly, none of which are even close to that bad. Most are virtually immediate..

I always figured it was all of the little 'extras' this site has, but it's just brutal. I'm sure I would spend more time here if not for that..

By the way, I don't post this to complain, but to give the powers that be a heads-up..
 
  • Like
Reactions: Graeman
Graeman

Graeman

Rank V
Launch Member

Off-Road Ranger I

2,876
Catalina Avenue, Tucson, AZ, USA
First Name
Todd
Last Name
Hoffmaster
Member #

4284

Ham/GMRS Callsign
KJ7CRJ
Service Branch
Air Force
I thought that it was just my computer or my wifi. So glad to read that others are having the same troubles.
 
Aaron Niemi

Aaron Niemi

Rank V
Launch Member

Member III

2,805
Spokane, WA
First Name
Aaron
Last Name
Niemi
Member #

11381

The homepage isn't loading the images and it's throwing this error:
external.php?type=js:143 Mixed Content: The page at 'https://www.overlandbound.com/forums/threads/page-load-times.14899/#post-223003' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://www.arrowpushengine.com/time/0?uuid=00361c6e-ce50-4cb4-b4f3-04530af7fd86&pnsdk=PubNub-JS-Web/3.7.2'. This request has been blocked; the content must be served over HTTPS.

It throws it every second or so...

You guys need some web-dev help?
 
nickburt

nickburt

Rank VII
Launch Member

Creator III

5,613
Wallasey, Wirral. UK
First Name
Nick
Last Name
Burt
Member #

2714

@Michael - can something be done please - load speeds are becoming quite painful for some of us.
I'm sure some of our subscriptions etc... is going towards paying for the XenForo service ?? So shouldn't they be providing a better service?
 
  • Like
Reactions: MazeVX and v_man
nickburt

nickburt

Rank VII
Launch Member

Creator III

5,613
Wallasey, Wirral. UK
First Name
Nick
Last Name
Burt
Member #

2714

I've just been looking at a build thread with quite a lot of pictures and got the following:


Timing:

13.6619 seconds

Memory:

40.580 MB

DB Queries:

21,762

13 seconds is for ever in terms of forum pages and 21K queries is ridiculous, but then 40 MB of memory .......
 
  • Like
Reactions: Aaron Niemi
Michael

Michael

Rank IX
Staff member
Founder 500
Member

Benefactor

15,584
Auburn, California, United States
First Name
Michael
Last Name
Murguia
Member #

0000

Ham/GMRS Callsign
KM6YSL
Hey all - it just so happens we are migrating the entire website to AWS - the work has been done and we are now hammering on it extensively. Expect this change to go live in the next couple weeks - then, lets have you guys hammer it.

M
 
  • Like
Reactions: HEYElliott, MazeVX and Tim
slomatt

slomatt

Rank V

Influencer I

1,723
Bay Area, CA
Michael said:
Hey all - it just so happens we are migrating the entire website to AWS - the work has been done and we are now hammering on it extensively. Expect this change to go live in the next couple weeks - then, lets have you guys hammer it.

M
Click to expand...
I'm glad to hear the site is moving to AWS. As part of that work are you able to look into why each page requires such a massive number of queries to render? The database server must be slammed. I'm assuming you are moving the database to RDS (Aurora?) which can take a ton of load, which should help
 
Craig M

Craig M

Rank VI
Launch Member

Advocate III

3,921
Haslet, Texas, USA
First Name
Craig
Last Name
M
Member #

5444

Holy smokes, I was just browsing and noticed how quick it felt.. Everything is loading at around .2 seconds now. That's fantastic!
 
Michael

Michael

Rank IX
Staff member
Founder 500
Member

Benefactor

15,584
Auburn, California, United States
First Name
Michael
Last Name
Murguia
Member #

0000

Ham/GMRS Callsign
KM6YSL
Chili said:
Holy smokes, I was just browsing and noticed how quick it felt.. Everything is loading at around .2 seconds now. That's fantastic!
Click to expand...
Yes! The site is MUCH faster now. Sorry this took so long guys. Thanks for being patient. Site performance and accessibility is a top-level concern, and sometimes it is very technical or expensive. Thanks for hangin on - We'll continue to have this be a high priority!

M
 
You must log in or register to reply here.
Top Bottom