"Find Databases Objects" is extremely slow !

[Philippe Malera]

When I search a text only in :
- Functions
- Procedures
- Package Specifications
- Package Bodies
- Type Specifications
- Type Bodies
- Triggers
No search in Tables or Views, only current schema.

It takes about 6 minutes to display 5 matching topic.

The same search on Toad take about 3 seconds to display (same filters). Means 120 times faster.

In an sql window, I run manually my text search in object sources, it takes about 2 seconds.
- SELECT DISTINCT type, name FROM user_source WHERE LOWER(text) LIKE '%hello world%';

Actually we are keeping a Toad license only for that feature.

Is there a chance to improve that feature in a next release ?

 

[Marco Kalter]

The "Find Database Objects" tool does a full text search on the complete DDL source of the selected objects, so it will indeed be slower than dedicated queries. We'll consider a "quick search" option for PL/SQL sources.

 

[koja]

It seems to me that somehow in the latest releases searching has become slower / I have made a change in config with that effect. Also searching often hangs when I go do something else... Any Ideas?
I already changed settings to My objects, current user, and only search in Functions, Procedures, Package Bodies, Type Bodies.

Searching about 1000 objects used to take 1 minute or so. It now takes about 5...

Regards,

Jan