Sometimes we ask, "what would the database we use? MySQL or SQL Server? Continue what is the impact, if the pros and cons? Here I provide an explanation.
MySQL is a database storage engine that is most widely used by web developers for free. Passions we not? But, for the expert version, there are paid. Of course his ability can be relied upon, have enough capacity realistic, which is about 60,000 tables with the number of records reached 5000,000,000 even to the latest version could've been a lot of it. In terms of security, is quite safe. Although not as powerful as Postgre or Oracle. This multiplatform database so that they can be applied in a variety of operating systems. MySQL is very suitable when applied to small and medium-class applications. The advantages of this database is the ultimate speed.
SQL Server is one of Microsoft's database storage engine. SQL Server is a database that is paid, meaning to use this database, we are obliged to spend some money to be paid to the company's Microsoft, but Microsoft also provides a free version (expert edition), but can only run on Windows operating systems only (monoplatform). In terms of security, the database has been classified as very secure. The capacity of the data did not reach Tera bytes, so it is able to be applied to large applications. SQL Server a lot of play in memory processing. For back-up of data, Microsoft SQL Server has many extensions of storage, including MBD, BAK.
From the above, then we can infer what the right database for our use.
MySQLf is very suitable when applied on server hosting (likely to lead to a mild application).
SQL Server is very suitable when applied to the company's internal (using their own servers / not use or rent another server), because it is also hosting server for SQL Server is very rarely encountered in the domain and hosting service provider. How've put across the differences between MySQL and SQL Server. That's the article from me, hopefully the information from php programming language blog is useful.
MySQL is a database storage engine that is most widely used by web developers for free. Passions we not? But, for the expert version, there are paid. Of course his ability can be relied upon, have enough capacity realistic, which is about 60,000 tables with the number of records reached 5000,000,000 even to the latest version could've been a lot of it. In terms of security, is quite safe. Although not as powerful as Postgre or Oracle. This multiplatform database so that they can be applied in a variety of operating systems. MySQL is very suitable when applied to small and medium-class applications. The advantages of this database is the ultimate speed.
SQL Server is one of Microsoft's database storage engine. SQL Server is a database that is paid, meaning to use this database, we are obliged to spend some money to be paid to the company's Microsoft, but Microsoft also provides a free version (expert edition), but can only run on Windows operating systems only (monoplatform). In terms of security, the database has been classified as very secure. The capacity of the data did not reach Tera bytes, so it is able to be applied to large applications. SQL Server a lot of play in memory processing. For back-up of data, Microsoft SQL Server has many extensions of storage, including MBD, BAK.
From the above, then we can infer what the right database for our use.
MySQLf is very suitable when applied on server hosting (likely to lead to a mild application).
SQL Server is very suitable when applied to the company's internal (using their own servers / not use or rent another server), because it is also hosting server for SQL Server is very rarely encountered in the domain and hosting service provider. How've put across the differences between MySQL and SQL Server. That's the article from me, hopefully the information from php programming language blog is useful.
Comments
Post a Comment