Red Gate forums :: View topic - SQL Data Generator, SimpleExpressions very slow
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 3
SQL Data Generator 3 forum

SQL Data Generator, SimpleExpressions very slow

Search in SQL Data Generator 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Jeppe K. Bloch



Joined: 28 Feb 2014
Posts: 1

PostPosted: Fri Feb 28, 2014 1:48 pm    Post subject: SQL Data Generator, SimpleExpressions very slow Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Mon Mar 03, 2014 11:35 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Mon Mar 03, 2014 3:05 pm    Post subject: Reply with quote

Can you send an example of your simple expression?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group