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

[Chris Wolf (JIRA)]

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

Chris Wolf commented on HBX-812:
--------------------------------

I have the problem, it takes 10-20 MINUTES for the metadata query to complete,
the same thing happens with middlegen.

DB: Sybase ASE-12.5.3
Eclipse: 3.2
Hibernate tools: 3.2.0-beta9a

I tried jConnect-5.5.6 and jTDS-1.2.  jTDS was faster, but did not return
all the tables.  I also had to configure autocommit=true.

Granted, there are 2700 tables in this database, however this is the reality in a large institutional environment with lots of legacy database objects.  I had
the tables filter configured to select only three tables, and that still did
not improve the metadata query time.  

This is pretty much a show-stopper for me to use tools or middlegen.

> 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