Members Main Page getting slow?

Zarxrax · Post by **Zarxrax** » Sat Feb 07, 2004 10:33 pm

Is it just me, or has the speed at which the members main page loads been slowing lately? I run firebird as my default browser, and i checked how long it took the page to load, I counted out 12 seconds. I then loaded up internet explorer to test it out. I hadnt visited the site using IE since I last formatted, so it wasnt in the cache or anything. It ended up taking a whopping 41 seconds to load. Later I tried loading the page again, took about 9 seconds this time. I then performed another try with firebird, with it taking 18 seconds this time.

By comparison, almost any other page on the site comes up within about 1 second of me clicking on the link.

I'm just guessing that this is because theres so much stuff that the main page has to check on when it loads... your opinions, your download problems, new journal entries, new downloads, and videos that you need to leave stars on. Am I on the right track here? If so, maybe it could be possible to make it optional for these things to load on your main page, and instead replace it with a link to said material?

LightningCountX · Post by **LightningCountX** » Sun Feb 08, 2004 12:23 am

its not only you zarxrax, it takes awhile to load on my IE browser as well. It almost feels like whatever banners they have on the site are huge jpegs

J-0080 · Post by **J-0080** » Sun Feb 08, 2004 12:42 am

Hrm, I just went and checked. I counted in at seven seconds. The odd thing is, it didn't seem to load this slow just a few days ago.

Corran · Post by **Corran** » Sun Feb 08, 2004 12:43 am

I've noticed this in a little more places than just that page. I notice it a lot in the forums too... It is almost as if the server is too busy searching the php database and serving requests to keep up.

trythil · Post by **trythil** » Sun Feb 08, 2004 1:40 am

It's impossible to say anything specific without looking at the interface and database schema.

I just tried to load the members main page, and it seemed to load fairly quickly. Then again, I'm trying this at an off-peak hour.

There was some lag in loading the right sidebar (all the statistics and "latest" stats), but it didn't seem too bad.

Still, simplifying the page doesn't sound like a bad idea. In particular, rolling up some of the sidebar entries into clickable links that go to other pages doesn't sound too terrible. I don't know how much of a speedup that could possibly provide -- everything on the right sidebar looks like it could be generated with some pretty simple queries -- but maybe somebody with greater knowledge of the .org database schema can fill us in on this.

Oh yeah, something related about the profile page. It's also slow. I think it might be the calculation of global and personal averages, but again, without knowledge of the schema I can't say anything for sure.

Anwyay, If that's true:
...well, not much to say, since I don't know how the site works with that data. It's possible that the code is storing that data and recalculating it only when an opinion is entered or updated -- and that would provide a significant speedup over recalculating the averages for every member page request -- but again I don't really know.

If the site is currently using the latter method of averages calculation, it might be worth it to try the former for at least the global average.

Lyrs · Post by **Lyrs** » Sun Feb 08, 2004 1:32 pm

yeah, i've noticed the slow down also...or maybe it's just my machine

or those crazy viruses

Jonathan02us · Post by **Jonathan02us** » Sun Feb 08, 2004 3:07 pm

Ive noticed this slow down too, i think the reason for this is because of the many people trying to access their Member page ... i dont kno, that could be a reason ...

... in a network of many people, the internet/server access slows down dramatically ... this might be the same case ...

Zarxrax · Post by **Zarxrax** » Sun Feb 08, 2004 10:10 pm

Yea, everything was slow as hell tonight. Taking upwards of a minute to view pages

J-0080 · Post by **J-0080** » Sun Feb 08, 2004 10:27 pm

Yeah, even now the forums are giving me lag between page loads.