mysql-random-data-generator

mysql-random-data-generator copied to clipboard

Slow? It seems to only insert about 400 rows per second.

5

Generating 10,000 rows in a table of 10 columns of VARCHAR(25) plus an auto-increment int primary key (11 columns total). Hardware is very powerful. 4 core, 24GB RAM, on NVME...

cbegin

get_float function is buggy

1

function get_float(in_precision int, in_scale int) do not work properly when precision is 1 and scale is 0 i.e table data type decimal(1,0)

xjjo

Mysql datageb bit

1

fixed for floating point issue, and added bit value

drewncrew

Consolidating the table update into a single database transaction improves performance (on my instance approx 35%, 1000000 line insert 155 secs -> 100 secs)

gbroiles

Why can't you specify the data format, if only you can support regular expressions

Nexus3932