So has the server been more stable?

[Cid]

EDIT: I have just experienced extreme lag, both in posting and browsing.

Yeah, cause I was repairing/optimizing the tables to see if it would help things out. We'll see.

[Zifnab]

I get the lag too. Sometimes it takes over a minute.

[Baloki]

Maybe you need to trim some of the users who have joined and never posted out the database to de-bloat it a bit?

[Loony BoB]

Eh, if it was nothing but db size, clearing the search index would cover a lot of it. Users don't take up tooooo much. Attachments are the killer.

[Baloki]

Eh, if it was nothing but db size, clearing the search index would cover a lot of it. Users don't take up tooooo much. Attachments are the killer.

then wipe attachments over 4/6 months old

[Loony BoB]

Nah, the older ones are generally the ones worth keeping. I don't think we'll be wiping the attachments anytime soon. That'd be a pretty rash (?) thing to do.

[Del Murder]

I'm having some lag right now. It comes and goes, and I have not noticed a change in this in the last couple days.

[eestlinc]

or you can disable all attachments

[escobert]

Or we could disable you

[Samuraid]

<mini-rant>Why did vBulletin have to screw up such a good piece of forum software by storing attachments in a mysql table. Who was smoking what when they made that decision?</mini-rant>

[Loony BoB]

<mini-rant>Why did vBulletin have to screw up such a good piece of forum software by storing attachments in a mysql table. Who was smoking what when they made that decision?</mini-rant>

It's actually optional to store them in the db and I personally would have them put into a folder on the site instead, I suppose now is as good a time as any to do this. We'll see what Cid thinks.

[Cid]

I'm all for that, if the transfer is simple.

[Rostum]

It's been running as smooth as can be.

[crono_logical]

Once attachments are out of the database, I suppose people will be able to view them without logging in?

[Loony BoB]

Not sure, I'll test that at Aiyon when I'm home.

EDIT: Actually, that was never an admin CP feature, now that I think about it - I think Cid's just disallowed remote linking completely at EoFF. If that's the case, it shouldn't be any trouble. However, we'll need to pull a downtime to get it done, and keep in mind that while it will probably cut the database by (at a guess) around half, if not more, there is the possibility that it won't affect the overall speed of the forums. I'm not really sure how attachments in the database works, only that I never liked the idea of it (the only time I'd use it is if I wanted to back up every single part of the forums on a single database file for some kind of reason, but even then you can just download the images via FTP and then zip 'em). I'm not sure how long it will take as EoFF is bloody big, however it is definitely a simple process.