This question is locked. New answers and comments are not allowed.
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
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
1 Answer, 1 is accepted
0
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.
Ivailo
the Telerik team
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!