Hello!
There's a need to design a system (something like online forum) that will be
storing huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means
that main table with indexes on it must be kept small?), while other messages
can be stored in rarely accessed archive (different table?). What's the best
practice for implementing archiving in MySQL? In Oracle there's an ability to
"switch off" part of the table and then move it to archive in background mode.
What about MySQL?
Thanks in advance,
Alex
P.S. This is the second time I post this question, sorry, problems with mail account
prevented me from reading the replies. The only one I got was abount using MERGE
tables which are still beta.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
