On Thu, 24 Feb 2005 11:39:41 -0500, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Well whichever, MySQL does not have that functionality. > I wish it did. But still, I do enjoy using MySQL rather > than MS-SQL. But that is my personal choice
Actually, MySQL has an entire field type for handling timestamps (TIMESTAMP) that autopopulates on create and then optionally again on every update, depending on how you write the query. Of course that makes your code a bit less portable. > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 24, 2005 11:25 AM > To: CF-Talk > Subject: RE: Pro/Con Moving from MSSQL to MySQL > > NOW()? Surely you mean GETDATE()? > > -----Original Message----- > From: Adkins, Randy [mailto:[EMAIL PROTECTED] > Sent: 24 February 2005 16:26 > To: CF-Talk > Subject: RE: Pro/Con Moving from MSSQL to MySQL > > Another point to consider is in MySQL you can not use A default date > field to be auto-populated as you can in MS-SQL using the NOW() > function. > > I had to modify my code to accommodate that function. > But for the most part I rather enjoy MySQL. > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 24, 2005 11:19 AM > To: CF-Talk > Subject: Re: Pro/Con Moving from MSSQL to MySQL > > On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman > <[EMAIL PROTECTED]> wrote: > > > > We are in the early stages of *thinking* about moving away from MS SQL > > > server and moving to MySQL. Can anyone give me a quick pro / con > > points for doing this or not doing this? > > I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done > a lot of work stradling both camps. I'd give you one fundamental piece > of advice: > > Don't do it just because MySQL is "free" (as in beer) > > Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited > is 5k/proc; MySQL is 500/server if you license it, which is optional for > most folks). But unless you're running *lots* of processors, the savings > are minimal. > > Pros/cons are a little hard to do unless without reference to specific > needs, but based on the scenario you have below (lots of read, little > write) MyISAM tables are probably faster than MS-SQL, and you can run > the app on more operating systems. And it's cheaper on the backup and > staging side since you don't have to pay MS rates for those licenses. > > > We have about 60 Databases set up on on a server that gets low > > traffic. Few thousand users per day. Mostly we use the database as a > > data storage. We have only a few stored procedures that probably > > really don't need to be Stored Procedures. The heaviest load we ever > > put on the SQL server is a few report admin pages where we use SQL to > > sum and count various stats about the users answers. > > MySQL is plenty powerful enough, though it benefits a lot more from > tuning than MS-SQL does in my experience -- both of those tools provide > similar *query* tuning options, but MySQL has hundreds of options that > can be tweaked to provider fine-grained control on tuning the server > while MS-SQL basically does a lot of self-tuning. > > > I know that we will have to rewrite anything that we have used MSSQL > > functions and MSSQL SQL commands. > > Less than you think needs rewritten -- MySQL has lots of common MS-SQL > (and Oracle, etc) commands built-in or aliased to the native MySQL > functions. The only difference in very common SQL off the top of my head > is the non-standard way Microsoft does queries with a rowlimit -- MySQL > uses SELECT xxxxxx LIMIT N etc instead of SELECT TOP N xxxxxx like > MS-SQL. > > -- > John Paul Ashenfelter > CTO/Transitionpoint > (blog) http://www.ashenfelter.com > (email) [EMAIL PROTECTED] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196329 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
