Re: size concers

[Rick James]

> How am I going to fill the table with test data...especially when we are taking about more that a million rows?

Virtually every programming language (Perl, PHP, Java, VB, C++, etc) can generate random numbers. I hope you know some language, because it will be easier to write a "random data generator" in that language than in SQL.

Start with just 100 rows because that will be very fast (perhaps 1 second to do the INSERTs) and it will give you enough data to debug the rest of your code. Later crank it up to 1M.