Preview Data Generation/Cancelling Preview Takes REALLY long

The simplest way to populate your database with test data.

Preview Data Generation/Cancelling Preview Takes REALLY long

Postby corycissell » Tue May 08, 2012 4:34 pm

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.
corycissell
 
Posts: 1
Joined: Tue May 08, 2012 4:06 pm
Location: United States

Postby james.billings » Wed May 09, 2012 10:58 pm

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.
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate


Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests