Database performanceFollow

I'm also a premium subscriber. I'm not sure what would cause this problem, whether it's script on the page or what. This seems to happen to me the worst when browsing the Beastiary. However, there's no lag at all if using Lucy to look up anything -- aren't Lucy and the beastiary on the same servers as Alla's? I've noticed that often the page seems to stall for 30 seconds to over a minute or more with a cable connection. Sometimes though, you can click "Stop" on your browser after 5 seconds or so and the page will show partially, often up until the part where the forums start. I just wanted to state this to possibly help find the problem, if it's not server-related.

Same for me, premium membership and it's sloooow or not responsive at all.

I am a premium member and have been for a few years now. It's jut this site that I have problems with as far as the page "hanging". It starts to load, and goes 3/4 of the way into and just hangs. Sometimes if I let it sit, it will eventually load, or I just keep hammering refresh until it finally goes through.

Some parts are fine, others are intolerable. It does this on all 3 of my pc's.

(an error occured while processing this directive)

Premium and same problem on multiple computers. I've got plenty of bandwidth too, so it aint me.

And has anyone from the management posted anything here about the same issue we're all talking about? No! I think the number of posts here about the same issue deserves, at the very least, a response from the people who run this website.

This is a quote from Illia regarding slowness issues (I am playing messenger here):

It can be found in its origin here on the Feedback Forum.

The new servers should be arriving "next week." How long it takes to get them active, I am not sure of. That is a developer thing.

my boss would ask me: so with 2 weeks dev and QA we look at CW 49 then?

I know this is getting fixed "soon" and all, but I just wanted to post my tracert to show how bad it really is (it's somewhat comical to me):

C:\Documents and Settings>tracert everquest.allakhazam.com

Tracing route to everquest.allakhazam.com [216.155.41.199]
over a maximum of 30 hops:

1 1 ms <1 ms <1 ms uiuc-isr-net.gw.uiuc.edu [130.126.208.1]
2 <1 ms <1 ms <1 ms t-core4b.gw.uiuc.edu [130.126.0.157]
3 <1 ms 1 ms 1 ms t-core1b.gw.uiuc.edu [130.126.0.225]
4 * * * Request timed out.
5 <1 ms <1 ms <1 ms 130.126.0.13
6 <1 ms <1 ms <1 ms 130.126.0.30
7 4 ms 1 ms 1 ms t-dmzo.gw.uiuc.edu [130.126.0.70]
8 1 ms 1 ms <1 ms t-dmzb.gw.uiuc.edu [130.126.0.86]
9 1 ms 1 ms 1 ms 192.17.10.30
10 1 ms <1 ms <1 ms GE-6-2-2-100-7-Iron-CHM-P2-7-Babylon-CHM-Colo.li
ncon.net [206.166.9.73]
11 5 ms 5 ms 5 ms POS-3-0-1-NapSOB2-CHI-P2-7-Iron-CHM-P2.lincon.ne
t [206.166.5.94]
12 4 ms 6 ms 5 ms p6-3.hsa1.chi1.bbnplanet.net [4.24.203.65]
13 4 ms 4 ms 4 ms ae-1-53.bbr1.Chicago1.Level3.net [4.68.101.65]
14 26 ms 26 ms 69 ms so-1-0-0.mp2.Philadelphia1.Level3.net [209.247.8
.65]
15 26 ms 27 ms 26 ms ge-11-0.hsa1.Philadelphia1.Level3.net [64.159.0.
146]
16 26 ms 27 ms 27 ms NUNET.hsa1.Level3.net [209.246.200.162]
17 30 ms 30 ms 33 ms FGL-PHIL.nni.com [216.107.27.69]
18 * * * Request timed out.
19 * * * Request timed out.
20 * * * Request timed out.
21 * * * Request timed out.
22 * * * Request timed out.
23 * * * Request timed out.
24 * * * Request timed out.
25 * * * Request timed out.
26 * * * Request timed out.
27 * * * Request timed out.
28 * * * Request timed out.
29 * * * Request timed out.
30 * * * Request timed out.

Trace complete.

It is most certainly a problem on Alla's end, not the user's. Those who do not have problems could be either hitting the site on off hours or are simply very lucky in their network connection's physical address.

I have 2.5mbps broadband, a hell of a powerful computer that I defrag regularly, an obsessive need to constantly scour for spyware and malware, and a pretty deep understanding of Internet technologies (network and website admin). Alla's is simply overloaded. The servers are inadequate, and/or the SQL database was inefficiently built and has grown too large and complex. It is most likely a combination of both. Fixing either will require either a serious amount of time to restructure the database or some heavy spending to upgrade the actual servers. Neither are something Alla will want to do, unless they get a lot of feedback about how annoying things are.

Like any business, they aren't going to spend money or time unless they have to. This isn't bad or wrong, it's just simple good business acumen. Our responsibility as the consumer is to make sure they know how significantly this situation is affecting our decision to give them money. This will force Alla to make a decision to either lose premium subscriptions, or make the investment to improve the web site. I'm betting on the latter. The folks who run Alla haven't proven themselves stupid thus far, and I doubt they will sacrifice long term revenue to save money in the short term. The only question is when this upgrade will happen. I'm hoping it will be soon, but it's up to us all to 'encourage' them to take care of matters as quickly as possible.

It's frustrating and annoying, and I find myself using other, free info sites more and more. But Alla's is still the best clearinghouse of EQ data I've found. I can find all the info here in one place, whereas I may have to visit two or three other sites to find what I'm looking for as an alternative. So I hope they'll get this little issue fixed soon. :)

Premium here also and this is the only site I have problems with. I hope the new servers get in soon as this is a great resource.

I am having a new weird issue. For some of the posts, Take for instance Suig's post on monster missions as an example, I can not see the first original post which contains the main information or the header with the thread name. On some threads I can see the first post, and thread name, and on others I cannot. That's just weird. I have rebooted and relogged on. I have "never filter" checked and made sure that is still on.

Is anyone else having anything similar to this?

/edit AH HA I just figured out that I cannot see the first post or header on any post that is 2 or more pages, so no polls, no OP on any really popular thread. I can see OP and header on one page posts.

Edited, Wed Nov 30 14:35:28 2005 by Kelti