Code assitance - autocomplete issues

[Motic]

Hi all,

Is there a way to enable some kind of caching for autocomplete option. One I press F6 it always takes several seconds to get a list of available objects, even in situations when I typed half of the name. It seems that for each F6 a new request to the database is executed and in my case where I work with thousands of tables and views it always takes too much time. Would it be better to have some session cache option? Are there any.

Thank You and Best Regards,
M.

 

[Marco Kalter]

There is no caching option. However, when you auto-complete a partial name of (for example) a table, there is no database access. All object names are fetched once when you connect. Can you confirm that completing a partial table is indeed fast?

 

[Motic]

Hello Marco,

Thank you for a quick answer.
I forgot to mention which version I use - it is a version 8.0.4.1514. So, we are using pretty big system, as already said ( ~1000-2000 tables and ~1000-2000 views ). Now I have checked again, a noticed that is not really always, but from time to time during the same session after entering schema name and first letter of table name (than pressing F6) it hangs for 5-15sec. I can confirm that sometimes is pretty fast, but not always.

Have you noticed similar behavior?

 

[Marco Kalter]

Pressing F6 after a schema name will indeed fetch all applicable objects. You can select the object types that are included through the preferences (Tools > Preferences > Code Assistant --> Describe Users). Other than limiting the object types the performance cannot be improved.