Activity overview
Latest activity by sderry
!) When you have associated a generator with a column, you have a selectable element "shuffle" . I was wondering how it was used.
4) Yes it would probably be multi-threaded when generating data for multiple tables. When generating data for a single table it appears to be a single thread doing the insert. I've reverted to running multiple copies of SQLDataGenerator to overcome this.
6) Yes there are a number of variants, was hoping someone had experienced such a large load and may have some guidance.
One thing I noticed is prior to doing the inserts SQLDataGenerator executes a "select count_big(*) from <tablename>" which has a major impact on the overall performance of the product. I expect the count is a result of not setting to truncate the table prior to starting the data generation. It would be nice to have an option to disable this select. / comments
!) When you have associated a generator with a column, you have a selectable element "shuffle" . I was wondering how it was used.
4) Yes it would probably be multi-threaded when generating data fo...
With further research was able to answer my questions 2, 3, 5. From prelimanary test runs data generation seems to be single threaded (question 4). / comments
With further research was able to answer my questions 2, 3, 5. From prelimanary test runs data generation seems to be single threaded (question 4).
Need to generate 9B rows in a single table
As I haven’t worked with the product before have some questions:
1) How is the option shuffle used? Seems to be related to null values?
2) To correlate column values would it be best to use a CS...