File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How does DbVisualizer hadle heavy load?

 
Vikas Kapoor
Ranch Hand
Posts: 1374
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2458
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Make sure that you use decent hardware as well and have patience when the script hangs.
 
Vikas Kapoor
Ranch Hand
Posts: 1374
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Roger! Mine script used to contain 65K. That seems to large.
 
Roger Bjärevall
DbVisualizer Support
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic