I think it's all a trade-off. I think MS Sql 2005 is great for developing. You get really good graphical execution plans, and it's pretty easy to tune your database. The gui tools make everything fairly easy to use. However setting it up is a bit of a pain. Especially if you are going for high performance. For that matter just getting the SQL server port to serve up to ColdFusion isn't straight forward, even if CF is on the same box.
On the other hand. I struggle with things in MySql like performance testing, adding constraints, and moving columns around in MySQL that are simple in MSSQL. But it is a lot easier to install, and get working properly, and for simple setups it's really not that harder to do most things than in MSSQL. I leave MS 2000 off, because well, it's 2007, and if your app has any life to it at all, you might run against end of life for 2000. I haven't run up against the performance limits of either, so I can't tell you one is better than the other. When I have my choice I go with MSSQL, as I am much more comfortable with it. Terrence Ryan I.T. Director Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
