Home › Forums › Lordyuanshu.com Bar › Forum Speed
- This topic has 15 replies, 5 voices, and was last updated 10 years, 3 months ago by Lord Yuan Shu.
-
AuthorPosts
-
October 18, 2013 at 6:27 pm #52599sonic.penguinModerator
The speed of posting on this forum has dwindled to a crawl. It takes like 3 minutes to post and go between screens… any ideas? :hook:
October 22, 2013 at 12:26 am #52607tynanbeKeymasternot sure what’s wrong with it really.
we’ve done what we can and are currently considering alternative hosting solutions…
:-?October 22, 2013 at 2:32 am #52608DragonAtmaModeratorTo be fair, we’ve had this problem for a while now; months at least.
But I thought it was just me; apparently not!
October 22, 2013 at 11:41 am #52609unfyModeratorForum speed is hit or miss.
Can’t really try to offer an explanation as to when it’s slow. Doesn’t seem to be a lot of folks posting (unless it’s spam that gets nommed) – cause there’s not a lot of posts every day.
How much control over the database do you guys have ? Have ya looked at, say, my.cnf for optimization options etc ?
<hr />
I’ve gone about switching from loading the forum root page for recent topics listing like old layout to using bbpress’s RSS functionality (http://www.lordyuanshu.com/forums/rss).
October 22, 2013 at 2:13 pm #52613tynanbeKeymastercurrently have full root access so we can edit all the configs or change the software etc.
whatever we do, things seem to work fine for short bursts and then fail horribly…
:scratch:
October 22, 2013 at 2:27 pm #52614unfyModeratorIf you enable some query logging do something on the forum, disable, copy queries log somewhere… and repeat the process for a few different things (browsing threads or posting, etc), can ya look at the queries that are being generated and try to figure out what exactly is going on ?
From what I’ve seen, reading the forum seems to generally go okay (unless all of LYS is down). Posting tends to be rather slow. Post’s would undboutedly be INSERT’s into the database while viewing posts would be SELECT’s. INSERT’s going slowly are typically caused by the backend is having to go through and update a bunch of indexes (which might be quite large ?).
Anyhoo, the reason for my question concerning recording the queries is to get a copy of them and to run them manually to see where the slow down is. Is it just one particular table, or or or etc. If it’s not the DB, then is it apache/php doing it ?
I’m sure you guys know what you’re doing, but just trying to throw ideas out there. We all love us LYSDOTCOM! :)
October 22, 2013 at 5:49 pm #52615sonic.penguinModeratorI also don’t think the main forum page gets updated with the correct times/previous posts. Maybe I’m just looking at it wrong q_q
November 9, 2013 at 12:01 pm #52689Lord Yuan ShuKeymasterYa, I too notice how slow things get when writing to the database.
Things are even worse when making posts on the main site. In the middle of posts, I constantly get a “database can’t connect” message at the top of the screen. I then have to have several minutes for it to go away so I can publish the post (which also takes forever).
Ultimately, our host is inept and hasn’t been able to solve these issues.
That said, we are close to getting a Dedicated with the owner of the wrestling sites we manage. It’ll be $220 a month, but I think it’ll be worth it. If you guys want to chip in, it would be much appreciated. I think it’ll result in not only more uptime and faster forum surfing, but improved rankings since rankings are affected by horrendous site speed (which hurts user experience which hurts bounce rate which hurts rankings).
Welcome to Lord Yuan Shu Walkthrough Guides ·
Huo Hu's Adventure started Destiny of an Emperor hackingNovember 10, 2013 at 8:40 am #52693sonic.penguinModeratorOuch, 220 a month? I’d say stick with the current option >_> or maybe have a google ad service.
- This reply was modified 10 years, 4 months ago by sonic.penguin.
November 10, 2013 at 8:55 pm #52696Lord Yuan ShuKeymasterA dedicated can have multiple sites on there. So it’s not like it’s $220 just for this site.
We do have Google Adsense on the site, but gamer types seem to be too savvy to click ads regularly. It makes maybe a $1 a day per 1000 visitors.
The existing hosting is free, since we do work for Hub. But yea, funny to work for a place yet not like their service :huohu: But I tire of the slowness just as everyone else.
Welcome to Lord Yuan Shu Walkthrough Guides ·
Huo Hu's Adventure started Destiny of an Emperor hackingNovember 10, 2013 at 9:55 pm #52697DragonAtmaModeratorTell them that the site does a wonderful job and deserves a promotion! :Þ
November 12, 2013 at 1:54 pm #52699unfyModerator$220 is way too steep unless you plan on making money with the server in some form.
There are plenty of dedicated servers in the $40-$70 a month range. Which, unfy.org VPS has been having issues and it’s provider aint being so great (they were up to this point after a couple years. Burst.net btw) … so I’ll prolly be taking a look at a cheap dedicated server again here soon :(.
Or if you want to spend a bit more money and get service beyond reproach and good hardware, I’d suggest:
I had an account through them for a year or so, and then convinced my work to get an account with them as well. They’re top notch in my books for “it has to work or else”.
http://www.esecuredata.com were fine folks too, although I never had to do a service ticket with them so can’t really speak on that part of their service.
November 13, 2013 at 6:54 am #52701Lord Yuan ShuKeymasterHey unfy, thanks for the suggestions. Either way I’ll have to check them out.
We were looking at HostGator, since that is who she had before. They’ve fallen off in quality a bit from what I’ve read, but since she’s familiar with them that’s what she wants to do. LYS is just tagging on, so to speak, since I do work for her. $175 the first month $219 recurring. She does make a fair share off things like Adsense and affiliate programs. And she needs a good dedicated because of resource-intensive SEO plugins (which also is why LYS requires a lot of resources too).
Hopefully we get this going sooner than later. One of the factors killing the site’s traffic and rankings while hosting through Hub.org is the horrendous site speeds. Takes like 15-20 seconds on average for each page here to load, which is going to hurt user experience, google rankings, etc.
Welcome to Lord Yuan Shu Walkthrough Guides ·
Huo Hu's Adventure started Destiny of an Emperor hackingNovember 13, 2013 at 4:07 pm #52702unfyModeratorLYS,
Can’t argue with going with a host you know :). All the power to ya!
Burst.net is kind of similar to HG in regards to quality going down a bit over the years. However, BN’s quality has dropped like a rock in the last year it seems :(. HG does have a pretty rock solid history, so that’s good news for us visitors :)
December 15, 2013 at 8:34 pm #52762sonic.penguinModeratorIs it just me, or are the forums running a lot faster than before?
-
AuthorPosts
- You must be logged in to reply to this topic.