New forum software is very slow

[Galmok]

Do remember that if you add too many indexes to spead up reads, writes can get very slow. I had a table with a supporting index and removing that index caused writes do from 2-3 seconds to near instant. Clustering correctly also means a lot. And do defragment the database (very important on rotating disks). Try to get a look at which indexes can be removed (if possible). The database could maintain information enough to give clues about this. Some databases also can suggest indexes to make.

Could also be a locking issue (table locks where row locks are enough).

At any rate, getting a clear overview over where the time is used is the first task. Hitting randomly and hoping will take too long.

[AdamK47]

This problem will always persist with the upgrade. The only way to avoid the slowness is to not come here anymore. Which, sadly, many have done.

[metroidfox]

I remember browsing this site on 56K (which is a crazy thing to say). This is nowhere near as bad. We're simply waiting on database reads/writes, but the page loads are almost instant.

[clerick]

Feels a lot better today! Snappy even.

It does kinda feel like im back to browsing on a 56k. But man this update really killed the already low posting count. Honestly is there no way to just roll back to the old forum even if we lose a few months worth of posts?

[andino]

Feels a lot better today! Snappy even.

[andino]

The site feels faster today. Still not as fast as it was but getting better.

EDIT: And then I hit post and watched it sit here for 30 seconds thinking....

[Ichneumon]

We did a tremendous amount of optimizing and creating db index keys and caching to make R3D run as well as it did on the ancient servers we hosted on forever. I have not had the bandwidth to get together with the team who made this absolutely necessary migration happen to talk/walk through possible optimizations. Will see what we can do.

While vB5 may be slower than old vB versions, I don't think it is our database size by itself that is the problem. We just need to dial in some of the caching and index keys over time.

[pax]

It also doesn't have a 20+yr old data base to deal with. Optimizing that may speed up the forum, but I'm not an SME on DB's :\

The best I can do is look at options at this point.

I like a necro thread as much as the next guy.... probably more... no a lot more... but maybe its time to archive some stuff?

[metroidfox]

Oh, and the initial request, and response were almost 2 seconds too.

Is there a testbed you can try out some changes on? Also, have you indexed the heaviest hit databases/tables?

[metroidfox]

It's definitely writing to the database that's the issue. Just refreshing this page + marking it as read is taking nearly a second.

I don't know what 'incrementNodeview' is, but that's almost a second too.

image.png

[Trunks0]

It also doesn't have a 20+yr old data base to deal with. Optimizing that may speed up the forum, but I'm not an SME on DB's :\

The best I can do is look at options at this point.

[pax]

https://forum.vbulletin.com/forum/vb...nnect-feedback

Its faster than the old site... quick and very snappy, every link is well under a second...

[metroidfox]

If we compare the vBulletin website with Rage3D, there is a pretty significant difference in speed. https://forum.vbulletin.com/forum/vb...nnect-feedback

Searching, and page loads definitely seem faster. I haven't tried posting, but I would imagine that is faster too.

By any chance, is Rage3D now running on VM instances? Because VMs suck at performance.

[andino]

What is the old DB programed in?

[Silent-Runner]

Ouch!

Sounds like we might need to move away from vBulletin then. And that sounds like a nightmare. Especially when it comes to migration on the old database.

i don't think that would even be doable, and even if it would take an absurd time to get it done.

[andino]

Ouch!

Sounds like we might need to move away from vBulletin then. And that sounds like a nightmare. Especially when it comes to migration on the old database.

[Trunks0]

9 members and 1004 guests.

Is there a way to limit the 'guests'? Maybe make people sign in before they can view?

From my understanding, it's not so much the user count. The slowness is how the newer version of vBulletin handles the forums large database of info. Despite being hosted on faster hardware than it ever was before.

[andino]

9 members and 1004 guests.

Is there a way to limit the 'guests'? Maybe make people sign in before they can view?

[Trunks0]

Unfortunately, the more I look into this, the more it seems like this is heavily related to the software itself. We are looking into what can be done. Sorry for the inconvenience

[Galmok]

I just wanted to comment on the new forum software.

While it looks good, it is much too slow. Each page load takes 2 seconds and this makes me reconsider visiting the site. I get annoyed waiting 2 seconds for each and every page load.