Which database best suits my program

Asked By maya hunter 10 points N/A Posted on - 03/28/2012

I am currently working on a medium size project, i used to work with MySQL server but my client wants me to use MySQL. I am concerned about its performance and how it will affect the speed of every process. I need assistance especially from those who have used MYSQL, thanks

• Status: Open
• Question Views: 802
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Head Jonathon

Go To Solution

Answered By Trixy Rasel 0 points N/A #109098

Which database best suits my program

 

Hi

Mysql and mssql both are fine for the medium size application. If you are using visual studio for programming it is better to use mssql, because it is easy to configure and handle. Speed of the process does not change considerably. If you know how to use quarry language well, then don’t afraid of mssql.it is good. 

About Trixy Rasel

Questions
1

Answers
37

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/06/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Head Jonathon 0 points N/A #109100

Which database best suits my program

Hi Maya,

MySQL and MSSQL both are mostly used database system nowadays. Both have advantages and disadvantages. MySQL has more advantage compared to MS SQL as its take less storage space and MySQL performs well on Linux, Unix Operating systems. You should have well knowledge to work with MS SQL. In MySQL all the foreign keys are not supported. When compared to recovery process MS SQL has more advantage over MySQL.

Thanks!

About Head Jonathon

Questions
8

Answers
115

Best Answers
48

• Vote Up 0 Vote Down

• Posted on - 12/18/2012
• Question Category: MySQL Server