Why not use partitioning?March 3 2010 at 6:24 PM
No score for this post
from IP address 188.8.131.52
Response to Thanks Glenn...Little more information, any thoughts?
Keep your data that changes hourly in one database, keep your historical in another database. Use transparent partitioning for users to see it all... Then you can manipulate each as needed. Am I missing something here? I read through the post twice.