calculated fields - performance problem

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
civic9
Posts: 10
Joined: Fri 01 Apr 2011 12:55

calculated fields - performance problem

Post by civic9 » Fri 10 Jun 2011 21:58

Hi,

We have performance issues with your driver under RAD XE when using calculated fields and an additional query in the OnCalcFields event. The same code under BDS 2006 with older driver works many times faster.
Can you investigate this?

Execution times:
1. BDS 2006, C++
Calc fields enabled - 2 seconds
Calc fields disabled - 1 second

2. RAD XE, C++
Calc fields disabled - 2 seconds
Calc field enabled - 25 seconds (!!!)

Download the sample app from:
http://www.netinfo.pl/oracleCalcFieldsTest.zip
In the zip file you will find:
CFTSourceCodeBDS2006.zip, CFTSourceCodeXE.zip - source code of sample apps (the same in both environments)
ObjectsSql.sql - sql script to create sql schema and insert sample data;
OnCalcFieldsTestBDS2006.exe, OnCalcFieldsTestXE.exe - compiled sample apps
dbexpoda30.dll, dbexpoda40.dll - your oracle dbexpress drivers

civic9
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Post by civic9 » Fri 17 Jun 2011 01:25

Hi,

AlexP - could you check the problem described above?
do you need more info?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 17 Jun 2011 07:42

Hello,

Thank you for the information. We've reproduced this problem. Now we are investigating the possibilities of such dbExpress behaviour on different IDE versions.
When we have any results, we'll let you know.

civic9
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Post by civic9 » Fri 17 Jun 2011 09:18

Thanks,

We have checked this again using dbexpoda30.dll from dbxoda 4.90.0.25 under bds2006 - performance is like under rad XE too (>20 seconds). So, this is not different IDE version issue, I think.

dbexpoda30.dll v.4.20.0.8 works well (but we can use this version only under bds2006).

civic9
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Post by civic9 » Tue 02 Aug 2011 20:56

Hi,

are you going to fix it in the next build?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Wed 03 Aug 2011 09:13

Hello,

We are still working on this problem.
We will try to fix it in the next version.

civic9
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Post by civic9 » Wed 24 Aug 2011 12:25

still not fixed in 5.00 beta.

we are waiting almost 3 months.
seriously - are you going to fix it?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Mon 05 Sep 2011 11:24

Hello,

We have fixed the problem.
This fix will be included in the next build.

Post Reply