, Conquer Club • View topic - Database Cleanup - Forum and Game Inactivity
Conquer Club

Database Cleanup - Forum and Game Inactivity

Suggestions that have been archived.

Moderator: Community Team

Post a reply

Database Cleanup - Forum and Game Inactivity

Postby max is gr8 on 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.
‹max is gr8› so you're a tee-total healthy-eating sex-addict?
‹New_rules› Everyone has some bad habits
(4th Jan 2010)
User avatar
Corporal max is gr8
 
Posts: 3720
Joined: Sat Jan 21, 2006 6:44 am
Location: In a big ball of light sent from the future
Top

Postby supermarcol on 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.
-SuperMarcol
User avatar
Sergeant 1st Class supermarcol
 
Posts: 153
Joined: Mon Jan 30, 2006 7:19 pm
Location: Montreal, Qc
Top

Postby Tr0y on Mon Mar 27, 2006 4:16 pm

Bigger databases create a bigger load on the CPU.
User avatar
Corporal Tr0y
 
Posts: 271
Joined: Mon Jan 23, 2006 1:26 pm
Location: Cary, NC
Top

Postby Hyperventilate on Mon Mar 27, 2006 4:18 pm

ouch....
User avatar
Private Hyperventilate
 
Posts: 24
Joined: Tue Mar 14, 2006 3:24 pm
Top

Postby Tubby Rower on 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.
User avatar
Sergeant 1st Class Tubby Rower
 
Posts: 349
Joined: Wed Mar 22, 2006 8:36 am
Location: under a rolling pin
Top
Post a reply

Return to Archived Suggestions

Who is online

Users browsing this forum: No registered users

Powered by phpBB