Design Component very slow

2 posts, 0 answers
  1. PEDRO
    PEDRO avatar
    1 posts
    Member since:
    Aug 2012

    Posted 22 Aug 2012 Link to this post

    Hi,

    Soon I will start a big project, so I'm testing some tools that could help to increase the productivity. One of the fundamental components will be ORM, we have a huge database and want to do the reverse engineering to generate the entities. After some research on internet I found Dataaccess, so I'm testing this. The first impression I had was that the designer and all the process are very slow. I'm doing this from my laptop (a recent machine with 8GB RAM) and the Oracle database is running on good server (we never had performance problems before). The schema has 240 tables and 2870 constraints and the reverse engineering process takes more than 35mins (25mins to get the information form database + 10 to generate the model). Is this normal? Has it some option/mechanism to increase the performance? Should I split the schema in several models?  
    I'm using the latest version of the Dataaccess 2012.2.816.1.

    Thank you
      
  2. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 24 Aug 2012 Link to this post

    Hi Pedro,

    The performance you are experiencing is unexpected for the size of your database. We would expect it to be read for less than a minute. 

    Is it possible for you to provide us with the database schema creation script, so that we can try reproducing this behavior locally and search for possible ways to optimize our performance, and in the same time to provide the best immediate solution for your case? 

    In case you can send the script, we are going to change the type of this thread so that you are able to attach files privately. I am looking forward to your feedback.

     

    Kind regards,
    Ivailo
    the Telerik team
    Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
  3. DevCraft banner
Back to Top