Poor performance in DirectMode

Poor performance in DirectMode

Postby hansjoergp » Fri 29 Sep 2017 14:54

Hello,

we have build now a version of our software with the dotConnect driver (as ORM-Mapper we use XPO from devexpress).
If we use it in direct mode the test application takes always about 1 min. If we use direct = false, than it takes about 8 sec.
Without devart the application takes about 6sec.

The application have calls to different stored procedures, inserts and selects.

What I can do to make the application faster? For us it is really important to use the direct mode, because we don't want to install the Oracle Client.

Regards
Hansjörg
hansjoergp
 
Posts: 4
Joined: Wed 31 May 2017 14:33

Re: Poor performance in DirectMode

Postby Pinturiccio » Tue 03 Oct 2017 14:47

Please create and Send us a simple test project, which reproduces the issue. If the project requires DDL/DML scripts for database objects, please send them too.

If your files have a size of several megabytes or more in total, you can archive them and upload it to our ftp server ( ftp://ftp.devart.com , credentials: anonymous/anonymous ) or to any file exchange server so that we could download it from there. And Send us the password to the archive.
Pinturiccio
Devart Team
 
Posts: 1996
Joined: Wed 02 Nov 2011 09:44

Re: Poor performance in DirectMode

Postby hansjoergp » Thu 05 Oct 2017 06:10

I will check if it is possible to extract the parts to a small programm..the application (and database) is really complicated and so this is not so easy..
hansjoergp
 
Posts: 4
Joined: Wed 31 May 2017 14:33


Return to dotConnect for Oracle