Takes 10 minutes for the first request to Database using LQML

Takes 10 minutes for the first request to Database using LQML

Postby thiruppathi » Tue 07 Jan 2014 02:59

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
thiruppathi
 
Posts: 11
Joined: Wed 22 May 2013 08:43

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

Postby MariiaI » Wed 08 Jan 2014 12:13

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/?Performance.html.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to dotConnect for Oracle