Hey, I have a mySQL db that has lotsa joins, lotsa filters, etc., and could potentially accumulate millions of records over a year or two. The db revolves around school semesters.
I'm worried about performance issues as time goes on. But I need to keep these records searchable. I've come up with a few ideas but thought you folks might have better solutions. Mine are: 1. Create a parallel set of tables prefixed with archive. Move records there every so often. 2. Allow users to create new tables with semester suffixes. Then search off those with a variable placed at the end of the table. 3. Save all the rollups/queries themselves in the db somehow. Anyone have ideas on this one? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4