Uploaded image for project: 'Tools (JBoss Tools)'
  1. Tools (JBoss Tools)
  2. JBIDE-2173

Performance problems in reverse engineering for databases with a lot of tables

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Critical Critical
    • 4.0.x
    • None
    • hibernate
    • None
    • -

      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.

        1. HSQLDB_JUnit_Screens.zip
          834 kB
        2. JBIDE-2173_20081119.zip
          13 kB
        3. JBIDE-2173_20100121.zip
          5 kB
        4. JBIDE-2173_20100126_2.zip
          5 kB
        5. JBIDE-2173_20100126.zip
          5 kB
        6. JBIDE-2173_20100127_patch.zip
          5 kB
        7. JBIDE-2173_20100211_patch.txt
          21 kB
        8. JBIDE-2173_20110316_patch.txt
          32 kB
        9. MySQL_JUnit_Screens.zip
          846 kB
        10. Oracle_JUnit_Screens.zip
          847 kB
        11. Postgre_JUnit_Screens.zip
          1.02 MB
        12. with-and-without JBIDE-2173_20100127_patch failed junits.jpg
          with-and-without JBIDE-2173_20100127_patch failed junits.jpg
          135 kB

            kaers@redhat.com Koen Aers
            vyemialyanchyk_jira Vitali Yemialyanchyk (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: