[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-812) Fetching Children of Database _crawls_.

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-812?page=comments#action_25230 ] 

Max Rydahl Andersen commented on HBX-812:
-----------------------------------------

how big is the db your are reveng'ing ?

the upcoming version will have more incremental schema reading for the ui parts, but the reveng used to do reverse engineering is just 
reading the tables you told it to read (e.g. what is in the db you pointed it to, thus using table-filter and/or schema-selection is a very good way of having this)

note, on mysql i have a 50 table schema and it completes in about 2-3 seconds or even less.

> Fetching Children of Database _crawls_.
> ---------------------------------------
>
>          Key: HBX-812
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-812
>      Project: Hibernate Tools
>         Type: Bug

>   Components: reverse-engineer
>     Versions: 3.2beta8
>  Environment: MySQL 5.0, Eclipse 3.2, JDK 1.5, Beta8 for Hibernate Tools
>     Reporter: Syd Poetry

>
>
> I just updated a bunch of components for Eclipse (mostly related to Visual Editor); added a couple of tables to my database, went to regenerate all the POJO clases .hbm.xml mapping files, and found that anything that queries the database schema runs abysmally slow.
> Updated the tools from beta6 to beta8 thinking it might be a conflict with one of the updates that was performed, still very slow (5+ minutes to retrieve a list of tables!).  Deleted all my hibernate-related XML files thinking it might be a parsing error, went to generate a new console file, and revenge.xml, found out that any listbox that tried to access the schema appeared to be hanging.  It finishes after much hard-drive crunching. I have 2.2 GBs free running windows XP, MEM usage is 856 MB out of 1.5 GB physical memory.  Just out of curiousity, is *anyone* else having this slow response for schema detection?  I'm wondering if I have to update another component like a driver or something like that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira