calculated fields - performance problem

calculated fields - performance problem

Postby 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

Postby civic9 » Fri 17 Jun 2011 01:25

Hi,

AlexP - could you check the problem described above?
do you need more info?
civic9
 
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Postby 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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby 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

Postby civic9 » Tue 02 Aug 2011 20:56

Hi,

are you going to fix it in the next build?
civic9
 
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Postby 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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby 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?
civic9
 
Posts: 10
Joined: Fri 01 Apr 2011 12:55

Postby AlexP » Mon 05 Sep 2011 11:24

Hello,

We have fixed the problem.
This fix will be included in the next build.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle