How to Generate 10 MILLION Sample Rows in SQL

[@natenatters]

Great video! You always do fair tests :) I wonder if you have seen MySQL 8 has been performing worse than MySQL 5.7 in some tests. Which MySQL version did you test with?

[@DatabaseStar]

Thanks! Yes, it was MySQL version 8.0.38.

[@walkingradiance9556]

it might be worth making a logarithmic plot for the runtimes because they differ so much like 20 seconds for SQL Server and 6900 seconds for MySQL for 10 million rows. it makes it harder to compare relatively small values when you plot really large values. log(10 million runtime).

[@DatabaseStar]

Good idea, that would have helped the chart.

[@walkingradiance9556]

you could generate a random real and convert it from absolute time to date for random date function.

[@DatabaseStar]

That's a good idea.

[@mrmoiz7939]

Plz make a video on Postgre Vs MySQL Vs MSSQL, Which SQL database to choose?

[@DatabaseStar]

Sure I can do that. Generally I recommend Postgres but I can make a video on it.

[@walkingradiance9556]

could you use a sequence object in Oracle similar to the generate series in Postgres?

[@DatabaseStar]

I don't think it can be done in the same way, because a sequence will generate the next number in order, and not a random value.

[@walkingradiance9556]

I installed Oracle 21c enterprise server-class directly on Windows. Do you mean Oracle 23 ai can only be installed on Windows with Docker?

[@DatabaseStar]

I think so, but I didn't look too closely at the other versions, and it may change in the future.