UniDac 4.6.12.0 / Delphi 2009 prof.: Install and performance problems.

[exbo]

Helo,

i have updated from UniDac 1.20.0.13 to 4.6.12.0 (Setup file "unidac46d12pro.exe").
Before installing i performed the follwing steps:
- Close RAD Studio 2009
- Remove UniDAC 1.20.0.13
- Remove all *dac*.bpl and crcontrols*.bpl files
- Remove *.dcu files from my project
- Install UniDAC 4.6.12.0.

After restarting delphi i got these error messages:
1) "The entry point of procedure "@Dbaccess@TCustomDADataSet@SetForeignKeyFields$qqr20System@UnicodeString" was not found in the dll "dac120.bpl""
2) Package C:\Program Files\CodeGear\RAD Studio\6.0\Bin\dclunidac120.bpl can not be loaded.
Package C:\Users\Public\Documents\RAD Studio\6.0\Bpl\EuaSecurity2009.bpl can not be loaded.
The specified procedure could not be found.
Should the package be loaded the next time the project will be loaded?

After delphi has started i looked in the package list:
- These packages were listed and checked
+ "EuaSecurity2009.bpl" ("C:\Users\Public\Documents\RAD Studio\6.0\Bpl\EuaSecurity2009.bpl")
+ "dclcrcontrols120.bpl" ("Devart Controls")
+ "dcldac120.bpl" ("Devart Data Access Components")
+ "dacvcl120.bpl" ("Devart Data Access GUI related Components")
+ "dclunidac120.bpl" ("Devart Universal DataSet Access components")
+ "unidacvcl120.bpl" ("Devart Universal Data Access GUI related Components")
- These package was listed but not checked
+ "DataSetManager120.bpl" (Devart DataSet Manager")

After opening my project i got the error "The procedure entry point "@Dbaccess@TCustomDADataSet@SetForeignKeyFields$qqr20System@UnicodeString" was not found in the dll "dac120.bpl"" again. Nevertheless i was able to compile the project.
After running my project i got the next shock: The performance was disastrous (perceived 10 time slower compared to the old components) .

Here are more informations about my developement surrounding and my project.

a) Developement surroundung:
- CodeGear™ RAD Studio 2009 Version 12.0.3420.21218 Professional
(Installed Updates: Help, 3, 4 (Database Pack Update))
- Other "Devart" component suites:
+ SDac for Delphi 5
+ MyDac for Delphi 7
- OS: Windows Vista (Build 6002: Service Pack 2)
- CPU: Intel(R) Core(TM)2 Duo CPU P8400 2 x 2,26 GHz
- RAM: 4 GB

b) Project information
- access to the following DBMS: Firebirg 2.5 (local) and MS SQL-Server 2005 Express (local)
- visualization the table data with the components from "DevExpress" (TcxGrid, TcxDBEdit, TcxDBLookupComboBox, ..)
- several master/detail relations and lookup fields.
- there is just a small master table with about 200 datarows and may be five detail tables. In the detail tables beetween 0 and 10 datarows are accociated with a master table datarow. One detail table contains images.

Any suggestions what i can do to get my project run in an acceptable performance?.

Thanks

[exbo]

Helo,

After restarting delphi i got these error messages:
1) "The entry point of procedure "@Dbaccess@TCustomDADataSet@SetForeignKeyFields$qqr20System@UnicodeString" was not found in the dll "dac120.bpl""
2) Package C:\Program Files\CodeGear\RAD Studio\6.0\Bin\dclunidac120.bpl can not be loaded.
Package C:\Users\Public\Documents\RAD Studio\6.0\Bpl\EuaSecurity2009.bpl can not be loaded.
The specified procedure could not be found.
Should the package be loaded the next time the project will be loaded?

i could eliminate the error. EuaSecurity2009.bpl was a package that i had created. It was linked with devart dcp files "dac120.dcp" and "unidac120.dcp" of the old version 1.20.0.13. Eliminating the package or recompiling the package solves the problem.

[ViktorV]

It is good to see that the problem with packages installation has been solved.
We could not reproduce the performance issue.
Concerning performance loss, please describe the problem in more details and, if possible, create a small test sample including the table creating and filling script, and send it to viktor*devart*com

[exbo]

i have send you a demo project.

the database consists of an embedded firebird server. But the performance degradation also can be reproduced with MS SQL Server 2005 (Express Edition).

A significant performance degradation occurs if a lookup resultset is filtered.

[exbo]

i have found the topic

TMSTable with 'Filter' setting very slow on Open

in category "Devart Forums ‹ Delphi Data Access Components ‹ SQL Server Data Access Components" which describes the problem similiary. If i use TUniTable.FilterSQL instead of TUniTable.Filter in the lookup field resultset then the performance loss does not occur. In the SDAC suite this problem should be fixed. In the unidac version newer than 1.20.0.13 this behaviour seemed to rise up again?

[exbo]

Hi ViktorV,

do you get the demo and see the performance loss using TUniTable.filter instead of TUniTable.FilterSQL in the lookupresultset. Every time i have to made changes in my project using filtered lookupresultsets i have to reinstall version 1.20.0.13 which is stable in this matter.

[ViktorV]

Excuse me, I have specified a wrong e-mail.
Please send your demo to viktorv*devart*com

[ViktorV]

We have already fixed the issue with perfomance loss in Master-Datail.
Please upgrade to the latest version of UniDAC (5.3.10), perform tests and notify us about the result.