Page 1 of 1
Database Cleanup - Forum and Game Inactivity
Posted:
Sat Mar 25, 2006 4:02 pmby max is gr8
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.
Posted:
Sat Mar 25, 2006 4:21 pmby supermarcol
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.
Posted:
Mon Mar 27, 2006 4:16 pmby Tr0y
Bigger databases create a bigger load on the CPU.
Posted:
Mon Mar 27, 2006 4:18 pmby Hyperventilate
ouch....
Posted:
Tue Mar 28, 2006 2:15 pmby Tubby Rower
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.