Needs advice
on
MySQL
and
MSSQL

We are planning to migrate one of my applications from MSSQL to MySQL. Can someone help me with the version to select?. I have a strong inclination towards MySql 5.7. But, I see there are some standout features added in Mysql 8.0 like JSON_TABLE. Just wanted to know if the newer version has not compromised on its speed while giving out some add on features.

READ LESS
4 upvotes·95.7K views
Replies (2)
Cofounder at Wanderloop·

MySQL 8.0 is significantly better than MySQL 5.7. For all InnoDB row operations, you'll see a great performance improvement. Also, the time taken to process transactions is lower in MySQL 8.0. Moreover, there has been an improvement in managing read and read/write workloads.

READ MORE
6 upvotes·65.3K views
Digital Developer at SpeakUnique·
Recommends
MySQL

MySQL AB doesn't implement anything in MySQL until they can find a way to do it efficiently and, often, more efficiently than other systems. So although I don't have experience with benchmarking JSON_TABLEs or similar new features, their development philosophy alone suggests that version 8 for the latest features would be a safe jump without sacrificing system performance.

READ MORE
5 upvotes·65.1K views
Avatar of Rafey Iqbal Rahman

Rafey Iqbal Rahman

Cofounder at Wanderloop