Direct Mode performance vs OCI mode

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Fri 21 Jul 2017 11:51

We understand your situation. However, at the moment we cannot reproduce the issue consistently. On some Oracle Clients OCI is about 30% faster than Direct, as you described. With other Oracle Clients the Direct mode is either faster or has the same performance. Please tell us the full version of your Oracle server and Oracle Client.

espiralms
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Post by espiralms » Wed 26 Jul 2017 06:36

Hello again

Oracle server version:
- Oracle Database 10g Release 10.1.0.2.0 - Production

Oracle client version (for OCI mode tests)
- 64-bit Windows: Version 11.2.0.1.0
- 32-bit Windows: Version 10.2.0.1.0
(both with same results)

Hope it helps
Best regards

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Mon 31 Jul 2017 15:11

We made big changes to our provider to improve performance in the Direct mode. We will create an internal build with these changes in the near future and send it to you. We will post here when the build is ready.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Wed 02 Aug 2017 15:28

We have answered you via e-mail.

espiralms
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Post by espiralms » Mon 14 Aug 2017 06:28

Hello
We have received the new assemblies for test, but we could not compile our testing app using those assemblies. We have replied to your email explaining the problem and we are waiting for response.
Thank you very much

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Direct Mode performance vs OCI mode

Post by Shalex » Tue 15 Aug 2017 10:09

We have answered you via email.

espiralms
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Post by espiralms » Thu 17 Aug 2017 11:48

Hello again

We finally could perform our tests: there has been a huge improvement in Direct Mode performance, but it is still quite slower that OCI mode.

We have provided all the results to your Support Team via email.

Please share that info with your development team, and several questions in order to continue with this matter:
- Estimated date for obtaining an official DevArt version that implements these performance improvement changes
- Will DevArt continue working on this matter? The performance diference is still noticeable.

Thank you very much for your assistance.
Best regards

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Thu 17 Aug 2017 14:16

We have answered you via email.

espiralms
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Post by espiralms » Mon 28 Aug 2017 08:49

Hello again.
We have sent response to DevArt Support team, hope it can help.
Thank you very much

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Thu 31 Aug 2017 15:49

Thank you for the provided sample. We have recieved it. We are investigating it and will notify you about the results in the nearest future.

espiralms
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Post by espiralms » Tue 03 Oct 2017 10:09

Hello again
We are still working about this topic with DevArt Support Team.
We have sent new data today.
Thank you very much

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Post by Pinturiccio » Fri 06 Oct 2017 09:43

Thank you for the new data. We have received it, and we are currently studying it.

Post Reply