Filter on TUniQuery is slow in Oracle.

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
roznicki
Posts: 14
Joined: Tue 09 Feb 2010 13:15

Filter on TUniQuery is slow in Oracle.

Post by roznicki » Mon 03 Jan 2011 13:44

During filtering dataset Unidac is using function
TOCIMetaData.GetIndexColumns which is very slow on some Oracle Servers (query duration approx 3 seconds). This is unnecessary operation (query is selecting index columns for Locate after filtering which is not necessary (BDE was moving to first record in set in this situation).
Please modify this behaviour.
Top
AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Tue 04 Jan 2011 09:42

Hello,

To avoid searching key fields you should manually set the KeyField property, in this case the TOCIMetaData.GetIndexColumns method will not be called.
We will investigate the possibility of changing this behavior in one of the next versions.
Top
Post Reply

Return to “Universal Data Access Components”