Problem solve Get help with specific problems with your technologies, process and projects.

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.

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 last published in January 2003

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.