Ask the Expert

MySQL versus SQL Server for Web site

I would appreciate your help in deciding the best database for our Web site. The site has ecommerce, chat, bulletin board, streaming video, and an application where physicians manage their office needs online, ie each physician will access his patients records online, as well as edit new information and add chemotherapy protocols and medical records for his patients. I was thinking of MS SQL Server, although others recommended MySQL. I can afford SQL Server, but is it really better? Is there any limit of concurrent users for MySQL? Is there any limit of transactions for MySQL? Is MySQL better because it operates on Unix? Please advise.

    Requires Free Membership to View

You are dealing with confidential patient data. You are also dealing with the necessity to secure your data and provide tiered access to that data. I would not under ANY circumstances place anything but publicly accessible data into MySQL. I'm sure one of your patients would not be happy if your Web site were hacked, and confidential information was stolen from your database. If someone is recommending using MySQL for something this critical to your business, I certainly hope you find someone else to work with for every aspect of IT related to your business.

Your options for the backend of a Web site with such sensitive data would be Microsoft SQL Server, Sybase, Oracle or DB2. If I were ever working with a medical firm or any other business for that matter that held my confidential data in their databases, and I found out they were using MySQL for storage, I would find another business to work with and would immediately launch an investigation into how my confidential data was handled and secured.

 

For More Information

This was first published in January 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: