Thanks, Jon. Speed is the primary area I am experiencing with the MySQL hosting I am currently using. However, in the big picture the currently host is well worth what they charge. I am looking at Intermedia.net for a critical site. Intermedia.net has less functionality, but in terms of up time and response Intermedia.net has by far the best I have seen on shared CF servers. They have MS SQL and I don't want to loose to the DB what I gained with the server loading.
All of that to say this, I seem to hear mostly positives about MySQL and a lot of negatives about MS SQL. Sometimes I think that might be more dissatisfaction with MS than objectivity? Nick At 04:47 PM 1/18/2005, you wrote: >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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191041 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
