> how about purging rows older than a month? Do you need to keep them? Yes.
> Archive them them to another database? We are currently archiving them to another table, where we compress the text. > Actually, I got a better idea. Have your master db which is huge and > holds everything. Then on a seperate DB run a table for each feedid > with the last 100 feeds for that id. That would be some 400000 tables. What about the "Drawbacks to Creating Many Tables in the Same Database" http://dev.mysql.com/doc/mysql/en/creating-many-tables.html > Have a cron job that runs continually updating those tables with current data. > > get it? I think so :) Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
