ok now that I'm a bit more coherent.........
if you go to gaiaionline.com/forum you can see the msg board counts etc without needing to register. - Gaia has 998,523,683 articles posted with 6,899,737 registered users. - Most users ever online was 86,738 on Thu Jan 04, 2007 3:00 pm - There are currently 22,875 users online Topics (articles) have as many as 78,000 replies. If you're not familiar with phpbb a topic has its own table and its post information has its own table along with users in their own table. Theres some joins etc that happen similarly to what you were referring to. Its always been my opinion we as developers get pushed into being DBAs on smaller projects far too often and we're usually not fully competent to handle it on some level. Its not a knock on you or I etc, but imho most application slow downs relate to database bottlenecks and thats why prime time DBAs can get paid a lot more than I do :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
