Subject: There is no comparision
Name:
SickOfItAll Date: 1/19/2002 12:33:15 PM (GMT-7)
IP Address: 66.169.234.32 In Reply to: Re: If only it were that simple... posted by
Chris Message:
Between SQLServer and MySQL. If I were to convert our company's primary web applications over to use MySQL instead of MS SQLServer 7, I would have to rewrite a ton of code:
1) No stored procedure support in MySQL. All of our delete routines use stored procedures for full rollback capability on any failure.
2) No triggers. We use triggers in multiple areas to send email notification automatically when a new row is created in some tables (such as an error logging table that stores the error information then sends an email to the web administrator) and several of the eCommerce solutions I have developed email the appropriate people when new orders are placed in the orders table. We also use triggers for various other tasks (too mundane to describe here).
By taking full advantage of the advanced features in SQL Server you can spread the work load across multiple servers, and free up the web server to do what it does best: handle HTTP requests.
But like I said, the next release of MySQL is supposed to finally add support for SP's and Triggers, so we'll see how it goes.
|