[
http://jira.jboss.com/jira/browse/JBIDE-2173?page=comments#action_12412096 ]
Max Rydahl Andersen commented on JBIDE-2173:
--------------------------------------------
i'm not sure what you expect...the console tree was never optimized for large
databases so for that specific usecase this is not surprising.
What I'm more worried about is if 500 tables in the db also takes ages from e.g. ant
or eclipse reverse engineering - it definitly should not.
Performance problems with rather big db - Hibernate Console view
can't process rather big amount of tables
----------------------------------------------------------------------------------------------------------
Key: JBIDE-2173
URL:
http://jira.jboss.com/jira/browse/JBIDE-2173
Project: Tools (JBoss Tools)
Issue Type: Bug
Components: Hibernate
Reporter: Vitali Yemialyanchyk
Assigned To: Vitali Yemialyanchyk
Priority: Minor
For test purposes I create org.hibernate.eclipse.console.test ->
org.hibernate.eclipse.console.db.test.BigDBCreateTest - the main goal of this class is
creation test database with specified number of related tables. Then with help of
BigDBCreateTest I create a big enough databases with different number of tables in it. And
then I try to test hibernate plugins performance. I create a configuration for my test
db.
In Hibernate Console I try to expand tree. Here is a time:
200 tables in db - takes 40 seconds;
300 tables in db - takes 2 minutes 45 seconds;
500 tables in db - too long I do not get results.
Remark: I use MySQL as test db. 3000 tables - too much for MySQL. Also - it is intresting
- when I create such big db - I try to expand Hibernate Console tree - I get MySQL
exception - but in this case Hibernate Console display all items quickly!
JBIDE-2162 is related;
JBIDE-2163 & JBIDE-2164 are related by implication - till the moment when I have
fixed its in my test environment - I can't see performance problems.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira