Direct Mode performance vs OCI mode
Direct Mode performance vs OCI mode
Hello again
We are planning to buy DevArt dotConnect for Oracle in order to use Direct Mode, but we are worried about performance.
This link (https://www.devart.com/dotconnect/oracl ... tMode.html) explains that performance is similar in OCI and Direct Mode, but it also says this: "Statement caching is not available"
Does it mean that query caching is disabled in Direct Mode in all cases?
We also examined the performance comparative:
https://www.devart.com/dotconnect/oracl ... mance.html
Regarding DevArt DotConnect numbers, are they measured with OCI or Direct Mode?
Thank you very much !!!!!
We are planning to buy DevArt dotConnect for Oracle in order to use Direct Mode, but we are worried about performance.
This link (https://www.devart.com/dotconnect/oracl ... tMode.html) explains that performance is similar in OCI and Direct Mode, but it also says this: "Statement caching is not available"
Does it mean that query caching is disabled in Direct Mode in all cases?
We also examined the performance comparative:
https://www.devart.com/dotconnect/oracl ... mance.html
Regarding DevArt DotConnect numbers, are they measured with OCI or Direct Mode?
Thank you very much !!!!!
Re: Direct Mode performance vs OCI mode
Hello again!!
Can anyone help?
Many many thanks!!!
Can anyone help?
Many many thanks!!!
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Direct Mode performance vs OCI mode
Yes, the OCI mode is faster then Direct, but the difference is negligible. If you find a significant performance difference between the OCI and Direct modes, please inform us, and we will study this issue.
So query caching is disabled in the Direct mode in all cases.
It is mean the following feature: https://www.devart.com/dotconnect/oracl ... ching.htmlespiralms wrote:This link (https://www.devart.com/dotconnect/oracl ... tMode.html) explains that performance is similar in OCI and Direct Mode, but it also says this: "Statement caching is not available"
Does it mean that query caching is disabled in Direct Mode in all cases?
So query caching is disabled in the Direct mode in all cases.
These are old examples. The OCI mode is used in these examples. We are working on an up-to-date performance comparison, but we can't tell any timeframe when it is done at the moment.espiralms wrote:We also examined the performance comparative:
https://www.devart.com/dotconnect/oracl ... mance.html
Regarding DevArt DotConnect numbers, are they measured with OCI or Direct Mode?
Re: Direct Mode performance vs OCI mode
Many many thanks for this response.
But I am a bit confused!! How can Direct Mode performance be equal to OCI, considering that statement caching is not available on Direct Mode?
I assume PL-SQL parsing operations are usually heavy.
Probable we lack some Oracle knowledge somewhere... Can you please illuminate us?
Best regards!!!
But I am a bit confused!! How can Direct Mode performance be equal to OCI, considering that statement caching is not available on Direct Mode?
I assume PL-SQL parsing operations are usually heavy.
Probable we lack some Oracle knowledge somewhere... Can you please illuminate us?
Best regards!!!
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Direct Mode performance vs OCI mode
We did not write that performance in the OCI and Direct modes is equal. We have written that OCI is faster than Direct, and statement caching is one of the reasons, but the difference in most cases is negligible. If you found a significant performance difference between the OCI and Direct modes, please inform us, and we will study this issue.
Re: Direct Mode performance vs OCI mode
Hello again
We have done some tests, please have a look.
We have a table in Oracle database, with 28 millions of row.
We have developed a very simple console application (C#) that connects to Oracle database (with DotConnect Standard edition). It performs a "select * from table" query, it iterates along all rows with a Reader.
The have done 2 experiments, both with the same Database, same data, same query (select * from table) and same code:
- Direct Mode: it spends > 240 seconds
- OCI Mode: 180 seconds aprox.
The query is all the same, with only one execution, so no caching issues involved. We have repeated many days in different days, and same results.
Could you please have a look? We can provide C# source code is needes (but its very simple)
Thank you very much
Best regards
We have done some tests, please have a look.
We have a table in Oracle database, with 28 millions of row.
We have developed a very simple console application (C#) that connects to Oracle database (with DotConnect Standard edition). It performs a "select * from table" query, it iterates along all rows with a Reader.
The have done 2 experiments, both with the same Database, same data, same query (select * from table) and same code:
- Direct Mode: it spends > 240 seconds
- OCI Mode: 180 seconds aprox.
The query is all the same, with only one execution, so no caching issues involved. We have repeated many days in different days, and same results.
Could you please have a look? We can provide C# source code is needes (but its very simple)
Thank you very much
Best regards
Re: Direct Mode performance vs OCI mode
Hello again
We need help with this issue, this is blocking our project for using Direct Mode in our deployment.
Can anyone please help?
Thank you very much in advance
Best regards
We need help with this issue, this is blocking our project for using Direct Mode in our deployment.
Can anyone please help?
Thank you very much in advance
Best regards
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Direct Mode performance vs OCI mode
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Re: Direct Mode performance vs OCI mode
Many thanks!
We will be waiting for the response.
Best regards
We will be waiting for the response.
Best regards
Re: Direct Mode performance vs OCI mode
Dear friends
Have you got any result with this topic?
This is a blocking issue for our project.
Thank you in advance!!
Have you got any result with this topic?
This is a blocking issue for our project.
Thank you in advance!!
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Direct Mode performance vs OCI mode
We are working on the issue and will post here when we get any results.
Re: Direct Mode performance vs OCI mode
Hello again.
Have you got any estimation for the response?
This is an important matter for us.
Thank you very much!
Best regards
Have you got any estimation for the response?
This is an important matter for us.
Thank you very much!
Best regards
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Direct Mode performance vs OCI mode
We will post some results on this issue this week.
Re: Direct Mode performance vs OCI mode
Ok, thank you very much.
This is a blocking issue for us.
Best regards
This is a blocking issue for us.
Best regards
Re: Direct Mode performance vs OCI mode
Hello again
We are still blocked and in need for an answer.
Please, can you help?
Thank you very much
We are still blocked and in need for an answer.
Please, can you help?
Thank you very much