Nick You are experiencing performance problems with your current hosting - are you sure its actually down to the database platform? Perhaps you would be better of looking at the db design, indexes etc. IIRC MySQl has a number of different table types which you can mix and match within the same database - this should allow you to change the storage type based on how you envisage the table(s) being used.
Just something to consider HTH Kola -----Original Message----- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: 19 January 2005 06:01 To: CF-Talk Subject: Re: OT: Lynx MySQL v Win2003/IIS SQL 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:191086 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
