How can we help you today? How can we help you today?

SQL Data Generator, SimpleExpressions very slow

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.
Jeppe K. Bloch
0

Comments

3 comments

Sort by
  • Brian Donahue
    Thanks for pointing this out. I will let someone know.
    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.
    Brian Donahue
    0
  • Brian Donahue
    Can you send an example of your simple expression?
    Brian Donahue
    0
  • fairyanna
    The backup was written to disk, but the RESTORE VERIFYONLY process did not complete, causing the job to hang.
    fairyanna
    0

Add comment

Please sign in to leave a comment.