]
Dmitry Geraskov updated JBIDE-2173:
-----------------------------------
    Attachment: JBIDE-2173_20110316_patch.txt
Patch made up to date
 Performance problems with rather big db - Hibernate Console view
can't process rather big amount of tables
----------------------------------------------------------------------------------------------------------
                 Key: JBIDE-2173
                 URL: 
https://issues.jboss.org/browse/JBIDE-2173
             Project: Tools (JBoss Tools)
          Issue Type: Bug
          Components: Hibernate
            Reporter: Vitali Yemialyanchyk
            Assignee: Dmitry Geraskov
            Priority: Critical
             Fix For: 3.3.x
         Attachments: HSQLDB_JUnit_Screens.zip, JBIDE-2173_20081119.zip,
JBIDE-2173_20100121.zip, JBIDE-2173_20100126.zip, JBIDE-2173_20100126_2.zip,
JBIDE-2173_20100127_patch.zip, JBIDE-2173_20100211_patch.txt,
JBIDE-2173_20110316_patch.txt, MySQL_JUnit_Screens.zip, Oracle_JUnit_Screens.zip,
Postgre_JUnit_Screens.zip, with-and-without JBIDE-2173_20100127_patch failed junits.jpg
 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.
For more information on JIRA, see: