Red Gate forums :: View topic - Preview Data Generation/Cancelling Preview Takes REALLY long
Return to www.red-gate.com RSS Feed Available

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

Preview Data Generation/Cancelling Preview Takes REALLY long

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
corycissell



Joined: 08 May 2012
Posts: 1
Location: United States

PostPosted: Tue May 08, 2012 4:34 pm    Post subject: Preview Data Generation/Cancelling Preview Takes REALLY long Reply with quote

Generating preview data of just 5 rows can take a crazy long time (5,6,10 minutes). Preview data is generated every time a table is selected, the generation criteria is change, or application defaults are changed.

I need to cancel the preview so I can complete my task. However, cancelling the preview generation can take a really, really, really crazy long time.

I have spent several hours already today just tweaking an existing project. It took a full work day to initially create it.

I want to set the manual foreign to "repeat keys" instead of "all keys unique" which would prevent the generation of specified 1 million rows - which isn't discovered until the actual data generation fails. Should this take 5 or 10 minutes per table to make such a small change?

The project has 28 tables. My workstation has 8 GB of ram and a Core i7 quad-core, hyper threaded CPU.

Task manager shows 4 cores of 8 in use. I'm guessing Data Generator 2 deadlocks.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Wed May 09, 2012 10:58 pm    Post subject: Reply with quote

Hi,
The preview should be pretty quick - do you definitely mean the preview in the screen of Data Generator itself? I can't think of any reason why 5 rows should take anything like that time, it should be effectively instant. My copy of Data Generator is still set to the default 100 rows on the preview and it's instant - even to a server on a different continent via VPN.
There's an initial delay where it first reads the schema; but even then this is only a few seconds.

Have you tried installing it on a different machine to see if the problem persists? I'm not even sure the preview rows touch the database (they are just virtual rows in the tool itself) so I don't think even deadlocks would account for this.
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