SQL Data Generator, SimpleExpressions very slow
Jeppe K. Bloch
Posts: 2
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.
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.
Comments
I would imagine Regex is faster - it's got a lot less to do by not hosting the DLR. Possibly other Python scripts are faster if you bulk-generate the entire column and return an array rather than a single.