IMHO, MySQL while stable, is still only just starting to mature in terms of features. A lot of new stuff has appeared in MySQL 4.x.
It depends on what all of your requirements are: will you be running replicated, load-balanced servers? Replication in MySQL is much easier (and much chaper per license ;) for me being a nix person compared to MS SQL. Try and think of every thing you will need for your current (and any future) applications such as stored procedures, views, triggers etc. This will give you a clearer understanding of which one is "right". In terms of performance, as you said: there are so many factors to consider. But generally, I think MySQL on Unix outperforms MS SQL on a Windows machine. But that is just more of a "feel". Also, make sure you look at Postgre-SQL during your evaluation. It is much more feature rich that MySQL. Regards, Jon On Tue, 18 Jan 2005 16:17:47 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > I realize this question encompasses a ton of other factors, but in general > if other factors are even as possible, are there significant performance > differences between > > MySQL on a Lynx machine and SQL on Win2003/IIS SQL? > > And, what are the magnitude of differences? > > Thanks, > > Nick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
