Database Cleanup - Forum and Game Inactivity

max is gr8 · Post by **max is gr8** » Sat Mar 25, 2006 4:02 pm

Lack maybe you should delete games more than 1 month old
Also you should also delete topics which are inactive for 2 weeks DA! DA! Now you can put the limit back up.

supermarcol · Post by **supermarcol** » Sat Mar 25, 2006 4:21 pm

I think it was the CPU load he was talking about. I don't think its related to the database. I could be totally wrong though.

Tr0y · Post by **Tr0y** » Mon Mar 27, 2006 4:16 pm

Bigger databases create a bigger load on the CPU.

Hyperventilate · Post by **Hyperventilate** » Mon Mar 27, 2006 4:18 pm

ouch....

Tubby Rower · Post by **Tubby Rower** » Tue Mar 28, 2006 2:15 pm

not as drastic of a difference if the tables are indexed correctly. We have a complex database at work and it's indexed fairly well. Some queries joining 2-3 tables with > 300k records doesn't take more than 1-3 seconds.