Hi,

we are currently evaluating other PL/SQL development tools than the one we are currently using. So far we are quite impressed by the functionality of the PL/SQL Developer, but there is one important issue:

Using the 'Find database objects - Full text search' is showinq a very bad performance. E.g. searching for a developer name in all the packages of a schema (approx. 2500 packages) takes about 15 minutes. Doing the same with Quest SQL Navigator takes about 60 seconds. The same applies if the query is done manually on sys.user_sources.

Are there any hints for improving the performance in this area? I've already tried single/double/multi session settings in the preferences, but I can not see any difference.

Searching in the database is an important item for us.

Please let me know if there is anything we/you can do regarding this performance issue.

Thanks in advance
Michael