down perfomance in object smartquery wiht Smartquery

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
migpal
Posts: 1
Joined: Fri 28 Jul 2006 19:37

down perfomance in object smartquery wiht Smartquery

Post by migpal » Fri 28 Jul 2006 19:42

I have a View in oracle that use to throught of smartquery, when I condition the View throught of where is delayed much, this is a problem of the component?

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 31 Jul 2006 14:07

To determine whether delay is caused by TSmartQuery component you can open same query in SQL Plus or other tool and compare time that is spent for this operation with time that TSmartQuery component opens this query.

Post Reply