If you are properly configured and indexed on your SQL machine it won't be as a big a problem as you may think. For some good insight visit http://go-gaia.com and phpbb.com. The founder of that site posoted some mysql tuning tips but they can apply to other Dbs as well. Go-Gaia is a roleplaying like community with msg boards and games and stuff. At any given time they have something like 3k to 20k people online and sommething like 10 million database records etc. ranted now they are clustered but they weren't at one point.
If you still need to go that route the archive table doesn't sound that bad. I've seen an application that only kept 30 days worth of archive in the live system and every night a scheduled task rolled off a day over to the archive mirror table. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4