Geeklog Forums

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

Which tables are growing large?

---

Geeklog components by PortalParts -- www.portalparts.com

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...)

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

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