Page 1 of 1

Takes 10 minutes for the first request to Database using LQML

Posted: Tue 07 Jan 2014 02:59
by thiruppathi
Hi,

We were using lqml to connect to the oracle database. It is taking more than 10 minutes for the database request from the model. Does the lqml supports pre-compiled views? or Any other way to reduce the first load time?. Our models had around 200 objects including tables, database views and functions.

Thank you
Thiru

Re: Takes 10 minutes for the first request to Database using LQML

Posted: Wed 08 Jan 2014 12:13
by MariiaI
Basically, the first initialization of DataContext could take some time to perform due to the fact that it should get each type in the model.

Please specify the following information:
- the query that takes a long time to perform;
- the versions of the Oracle Server and Oracle Client (if the Direct mode is not used), etc.
We would be very grateful if you provide us with a sample project with your LinqConenct model, so that we are able to investigate the performance issue and find the solution for you.

Please also refer to http://www.devart.com/linqconnect/docs/ ... mance.html.