Devart Forums

Hi,

My query is related to http://www.devart.com/forums/viewtopic. ... 16eb1a7f36

Basically we use TSmartQuery quite extensively through out our system - and since upgrading to 6.25 from 5.8, the performance of our system has been destroyed. We discovered that the multiple queries to all_tab_columns are the root cause of the problem. Can you suggest something so help fix this problem.

TOraQuery sounds like a good substitute - I'm not keen on changing our code because we're nearing release date of our system and TSmartQuery is used everywhere.

Has this situation been improved in newer releases of ODAC? Can you make some other suggestions?

Regards

You can set the ExtendedFieldsInfo option of TSmartQuery to False. In this case the queries to ALL_TAB_COLUMNS are not performed.

Is there any more documentation about what ExtendedFieldsInfo does? What affect (besides not running that extra query) does turning this off have? Thanks for any info!

-Mark

This option enables or disables executing additional queries to detect the table for each field.

If you set this option to False, ODAC considers that all the fields without table name prefix belong to the first table in the FROM list.