Takes 10 minutes for the first request to Database using LQML

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
thiruppathi
Posts: 11
Joined: Wed 22 May 2013 08:43

Takes 10 minutes for the first request to Database using LQML

Post by 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

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Post by 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/ ... mance.html.

Post Reply