There is no comparision


[ Follow Ups ] [ Post Followup ] [ CPU-Central Message Board ] [ Home ]

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.

[ View FollowUps | Post Followup | E-Mail Sender | Main ]


[No follow-ups for this posting]

Post a Followup

Name:
E-Mail:

Subject:

Comments:

Optional Link URL:
Link Title:
Optional Image URL:
Upload some images for this post


[ Follow Ups ] [ Post Followup ] [ CPU-Central Message Board ]