Posted on: 03/19/04 07:12am
By: Anonymous (mark)
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
Splitting SQL table
Posted on: 03/19/04 08:35am
By: Blaine
Which tables are growing large?
Splitting SQL table
Posted on: 03/19/04 09:08am
By: Anonymous (mark)
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...)
Splitting SQL table
Posted on: 03/19/04 09:47am
By: Dazzy
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
Splitting SQL table
Posted on: 03/19/04 05:39pm
By: Blaine
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.