I'm running SQL 2k for the lists and have some new enhancements (like full text searching) going in soon. I've got a question about the best way to store and retrieve the data. With a DB of 300,000 records with about 100,000 records per year, is it better to have all of the records in a single table or would it be better to have multiple tables with each years records? On one hand I'd have a single huge table and on the other I'd have 1 table for each year with about 100,000 records. Which would be the better? Is there any downside to having a single large table? Thanks
Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
