wood burning stoves*
The moose likes JDBC and the fly likes How does DbVisualizer hadle heavy load? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How does DbVisualizer hadle heavy load?" Watch "How does DbVisualizer hadle heavy load?" New topic
Author

How does DbVisualizer hadle heavy load?

Vikas Kapoor
Ranch Hand

Joined: Aug 16, 2007
Posts: 1374
I have worked with couple of DB Tools like TOAD, MySQL Admin, SQLYog and SQLDeveloper.
The common problem that I have seen is when the script is large like thousands of SQL commands (DDL/DML), it hangs up.
I don't have any experience of any version of DBVisualizer. To workaround it I copy limited part and execute it. So I would like to know how does DBV address this thing?
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Vishal,

A lot of parameters are involved here so it is difficult to say how many statements can be executed in a single run. We've done tests with 20K row scripts (INSERT statements) without seeing any noticeable performance problems.

Best Regards

Roger
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
Make sure that you use decent hardware as well and have patience when the script hangs.
Vikas Kapoor
Ranch Hand

Joined: Aug 16, 2007
Posts: 1374
Thanks Roger! Mine script used to contain 65K. That seems to large.
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Vishal,

No I wouldn't say a 65K script it is too large. Give it a try. If memory is an issue
then you will need to extend the memory allocated for Java. Read more in:

http://www.minq.se/products/dbvis/doc/faq/faq.jsp#6.3

Best Regards

Roger
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How does DbVisualizer hadle heavy load?
 
Similar Threads
Using DbVisualizer & Other Tools for Database Table Navigation
DbVisualizer vs Squirrel SQL
DBVisualizer - Versioning
DBVISUALIZER: Connection management
DbVisualizer: Does it have any forum