What are the challenges you face when working across database platforms? Take the survey

SQL Data Generator, SimpleExpressions very slow

Jeppe K. BlochJeppe K. Bloch Posts: 2
edited December 31, 2014 7:59AM in SQL Data Generator
My SimpleExpressions generator is extremly slow. It do not matter if its a complex expression or simply inserting a constant. Casting to any specific type do not affect speed either.

In my current table of some 15 columns i can using a regex generator for the specified column generate 200.000 rows in seconds.

Using a SimpleExpression for the column instead slows down the whole process to 20.000 rows in 5 min.

Using PythonScript generator is as fast as the regex.


Sign In or Register to comment.