Toad World® Forums

How to speed-up test data generation


#1

Hello,

I am a new Toad for Oracle (12.9.0.71) user.

I am testing the generate data function or utilities from Schema Browser.
The options selected are:

RAMDON DATA ENGINE: DBMS_RANDOM
TRANSACTION COMMIT MODE: COMMIT WORK
Disable constraint before data generation
Disable triggers before data generation

With 5 samples it takes about 4 seconds
with 50 samples after 10 minutes the process is not completed.

Could you provide me the hints to improve the speed data generation such as toad configuration, settings and so on.?

regards,
alepage


#2

Hi alepage,

Are you saying you’re only inserting 5 records in 4 seconds, or 50 records after 10 minutes? If so, I suspect something else may be going on in your database. The DBMS_RANDOM engine does the majority of its work on the database server, so it shouldn’t take nearly that long to generate random data using the DBMS_RANDOM generator. As a quick test, I just did one on a remote database that I have access to, using the settings you listed, but generating 1000 records, and it took less than two seconds.

Out of curiosity, how many columns are in the table in which you’re trying to generate data? Have you tried turning on SQL Spooling (Database -> Spool SQL -> To screen/file) to see if there are any other queries being run at the same time?

-John