all_tab_columns

Donovan.Hutcheon · Post by **Donovan.Hutcheon** » Sun 14 Jun 2009 19:39

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

Plash · Post by **Plash** » Mon 15 Jun 2009 05:31

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

MarkF · Post by **MarkF** » Wed 17 Jun 2009 10:19

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

Plash · Post by **Plash** » Thu 18 Jun 2009 06:31

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.