Red Gate forums :: View topic - hierarchic view...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

hierarchic view...

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
randyv



Joined: 28 Feb 2007
Posts: 113

PostPosted: Thu Mar 15, 2007 5:50 pm    Post subject: hierarchic view... Reply with quote

Hello -

Just wondering what the upper object limit is for SQL DT2?

Here is why I ask - I'm in the middle of a data conversion project going from one ERP system to another.

In the new ERP system, I have a couple of databases that I want to load into the application and display using hierarchic layout.

Now, bear in mind these are commercial ERP databases (LOTs of tables, views, sprocs, etc.)

The baloon layout comes up after a few minute processing.

I save the project. Then I select hierarchic layout.

I'm on an IBM 3000 J Series Athlon X2. Running Windows 2K3 server.
(That's my PC running DT2). The last time I tried this was 2 days ago, left it running for over 48 hours, all that ever happened was the progress meter kept spinning indicating it was chugging on the layout... so I finally killed it.

Hence the question -

Thanks.

Randy
_________________
What we do in life echoes in eternity <><
Randy Volters
Back to top
View user's profile Send private message Send e-mail
Dan J Archer



Joined: 10 Oct 2005
Posts: 81
Location: Red Gate Software

PostPosted: Fri Mar 16, 2007 12:33 pm    Post subject: Reply with quote

Hi Randy,

There's no hard limit on Dependency Tracker, but as you've noticed some of the layouts perform significantly worse with substantial numbers of objects.

Version 2 has been tested with up to a couple of thousand objects, though not all layouts are performant at this point. On the other hand, 48 hours does seem very excessive. Was the CPU usage for Dependency Tracker still high at that point? I'm not certain, but this could be a bug in our layout algorithms.

I'm not sure if you can send us the data in question, but if so we may be able to try and diagnose the problem.

All the best,

Dan
Back to top
View user's profile Send private message
randyv



Joined: 28 Feb 2007
Posts: 113

PostPosted: Fri Mar 16, 2007 1:08 pm    Post subject: sending data... Reply with quote

Dan -

Zipped file OK? Who do I send it to?
_________________
What we do in life echoes in eternity <><
Randy Volters
Back to top
View user's profile Send private message Send e-mail
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