03/19/04 07:12am  

mark

Anonymous
How can I split SQL table ?
Ex.: curent table from 1 January 2003 till now and rest= archive table.
My curent geeklog table grows fast (>100Mb)

regards,
Mark
 03/19/04 08:35am  
Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Which tables are growing large?
Geeklog components by PortalParts -- www.portalparts.com
 03/19/04 09:08am  

mark

Anonymous
I have more than 250 post per day.
I just want to limit post to the last 12 months for ex.
(split database by year: 2003, 2004...)
 03/19/04 09:47am  
Status: offline

Dazzy

Forum User
Full Member
Registered: 07/19/03
Posts: 200
OT:
I am nowhere near that but I can see it becoming a problem in the future!

Any chance of some sort of 'prune' function for the forum Blaine?

Many thanks
Dazzy
 03/19/04 05:39pm  
Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
It is not an easy hack to use more then 1 database. All the SQL Class calls assume a single DB and therefore the code does not need to pass around the database connection instance.

Adding a feature that moved older articles and comments to another database would be a lot of work - as a first pass estimate.

It certainly would be easier to write a utility that deleted older content or older content that is not popular.
Geeklog components by PortalParts -- www.portalparts.com