Direct Mode performance vs OCI mode

Re: Direct Mode performance vs OCI mode

Postby 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.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Postby 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
espiralms
 
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Postby 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: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Postby Pinturiccio » Wed 02 Aug 2017 15:28

We have answered you via e-mail.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Postby 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
espiralms
 
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Postby Shalex » Tue 15 Aug 2017 10:09

We have answered you via email.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Re: Direct Mode performance vs OCI mode

Postby 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
espiralms
 
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Postby Pinturiccio » Thu 17 Aug 2017 14:16

We have answered you via email.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Postby 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
espiralms
 
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Postby 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.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode performance vs OCI mode

Postby 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
espiralms
 
Posts: 17
Joined: Mon 22 May 2017 11:46

Re: Direct Mode performance vs OCI mode

Postby Pinturiccio » Fri 06 Oct 2017 09:43

Thank you for the new data. We have received it, and we are currently studying it.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

Previous

Return to dotConnect for Oracle