Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases 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 and Relational Databases
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
 
Have you checked out Aspose?
 
subject: How does DbVisualizer hadle heavy load?
 
jQuery in Action, 3rd edition