I'm building an application where the amount of data in a table will be growing fairly quickly. The particular application is a little complicated to explain, so for simplicity, let's say I was building a blog app in the following enviroment.
Linux server w/apache MySQL 4.1 Coldfusion 7.02 I have 20,000+ users now (increasing at a rate of 300+ per month), and let's assume all will be making blog posts (2-3 per week). That's 60,000 entries per week. Should I have 1 table where I store the blog posts, writing the ID for the specific user in a column so I can retrieve only his/her posts when they are viewing their blog? OR Should I setup my code to create a new table for each user's blog posts, and then pass the table name dynamically when retrieving his/her posts? OR Split the data some other way? Thanks in advance for any recommendations. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4