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: 1950
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: 14
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: 1950
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: 1950
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: 14
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: 7602
Joined: Thu 14 Aug 2008 12:44

Previous

Return to dotConnect for Oracle