MsSQL vs MySQL

Question

Hi All I have a good hands on MsSQL but I want to know about MySQL please help me out. 1. What is the maximum size of database that MySQL provide? 2. Whether the stored procedure and join query are faster than the MsSql? 3. Whether MySQL is user friendly as compare to MsSQL? 4. Does it provide all the features that MsSQL provide? 5. Which one is more powerful?

Jignesh Trivedi · Answer

hi Please my comment inline... 1. What is the maximum size of database that MySQL provide? The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes not by MySQL internal limits. please refer.. http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html 2. Whether the stored procedure and join query are faster than the MsSql? NO. 3. Whether MySQL is user friendly as compare to MsSQL? yes. 4. Does it provide all the features that MsSQL provide? no MSSQL has feature like CDCCTDatabase MirroringDatabase snapshot etc are not available in MySQL. 5. Which one is more powerful? ofcourse MSSQL. More information please refer.. http://www.mssqltips.com/sqlservertip/1920/microsoft-sql-server-vs-mysql/ hope this will help you.