CODEWITHSUNDEEP
mysqldatabaseperformancephpmyadminbenchmarking
Peter
Peter

Reputation: 4151

MySQL Benchmarking, Pre-Production

Is there a way to benchmark SQL queries while in the development phase of a project?

The table in question only has a few sample rows in it, but I'd like to benchmark some queries before the number of rows reaches thousands, millions, billions, trillions, gazillions, whatever...

Is the only option to populate the table with thousands of rows of sample data?

I know very little (nothing) about benchmarking SQL, so detailed = better!

Thanks.

Upvotes: 1

Views: 550

Answers (1)

S.Lott
S.Lott

Reputation: 391962

Is the only option to populate the table with thousands of rows of sample data?

Yes.

detailed = better

Nothing more can be said. You need full volumes of data.

Upvotes: 1

Related Questions