Re: size concers
Posted by:
Rick James
Date: August 31, 2014 06:06PM
> 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.
Subject
Written By
Posted
Re: size concers
August 31, 2014 06:06PM
September 01, 2014 02:29AM
September 19, 2014 12:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.