Is it true that Vanilla forum's memory usage gets worse as the community grows?
This is one of the negative things I have heard about Vanilla (source):
@Gillingham said: I have ~7k users on my forum. Vanilla needs a decent amount of memory setup for mysql to function well. A lot of the queries relating to activities are especially bad so I manually edited out the Activities tab from the main navigation. There are still considerable queries that end up happening without using indexes and when your activity table has ~5M rows those can take a longgg time.
Does that apply to the current stable version of Vanilla? or Has it been fixed already? I am a tad-bit worried.
Best Answers
-
luc ✭✭
Well, it all depends on the amount of memory he calls "decent".
Nowadays, memory is quite cheap.The important thing there was surely that they are/were no index for the activity table.
0
Answers
Well, it all depends on the amount of memory he calls "decent".
Nowadays, memory is quite cheap.
The important thing there was surely that they are/were no index for the activity table.
Activity is now well indexed, you can also use vanilla routes to ensure that it is never reached.
grep is your friend.
@x00 : Thanks for chipping in yet again.
I didn't know that. Checking out the documentation for Routes.