MySql vs Sql Server

Hi guys

i am currently still developing my program using PHP, HTML and Mysql.

When eventually in use the database might get quite large as it will have Photos, Documents Etc. i need to know can Mysql Handle this or should i move to SQL server. and if so how much Programming change will have to be done from PHP side.

thanks

Does your existing code use MySQLi or PDO?

MySqli

MySQL able to handle databases with billions entries. So, I see no problems with it. Another question: would you save all your contents directly in database? Why?

I am currently developing from my laptop so the test database is loaded on the pc using Xamp.
so when im done i can basically migrate everything to a server ? with minimum effort.

i probably wont save all of it to the database but it will definitely have a lot of entries as it will be used for building maintenance

I am currently developing from my laptop so the test database is loaded on the pc using Xamp.
so when im done i can basically migrate everything to a server ? with minimum effort.

Yes, why not?

i probably wont save all of it to the database but it will definitely have a lot of entries as it will be used for building maintenance

I worked with MySQL databases for web-shops, with incredible size and last. I don’t believe, that gonna be a problem.

Thanks a lot, Was worried for a while

Yes, most of any problems I’ve had with MySQL were because of my poor design / poor queries, not with MySQL itself. I have a feeling you will hit OS limits before you hit MySQL limits.

https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.5/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation specific to your operating system.

IMHO the listed “full-table fixes” are worth a read

If you encounter a full-table error, there are several reasons why it might have occurred:

If you have not already done it then try to make your database code separate from the other code.

The point I think @cryptichorizon was making is that, as you use mysqli rather than PDO, moving to SQL server would require rather more work. PDO can connect to MySQL, SQL Server, Postgres and a load of other stuff, where mysqli will connect only to MySQL databases as I understand it. For future projects where you might want to use a different database engine, perhaps PDO would be worth considering, as the only change required would be the database connection routine, and perhaps some queries if you have used syntax that the other database does not support.

2 Likes