Toad World® Forums

12.5.0.8 Picklist-dropdown - Performance

When working with larger documents, picklist-dropdown cannot be used any more with the new beta.

Reproduction:

  1. Generate Test-Procedure like this:
    SELECT ‘DECLARE t NUMBER; BEGIN’ FROM dual UNION ALL
    SELECT ‘t := dbms_utility.get_time();’ FROM dual CONNECT BY ROWNUM <= 300 UNION ALL
    SELECT ‘END;’ FROM dual;

  2. Copy/Paste the result into a new editor window

  3. Trigger picklist-dropdown.

  4. Wait
    The last time I tried it, I got an AV. ELF available if required.

This problem seems to depend on the position in the file, picklist is displayed immediately for first lines of source, and takes long for the last lines.

Please send the ELF.

Thanks,

Michael

On 12/17/2013 05:29 AM, Peter Lang wrote:

12.5.0.8 Picklist-dropdown - Performance

Thread created by Peter Lang
When working with larger documents, picklist-dropdown cannot be used any more with the new beta.

Reproduction:

  1. Generate Test-Procedure like this:

SELECT ‘DECLARE t NUMBER; BEGIN’ FROM dual UNION ALL

SELECT ‘t := dbms_utility.get_time();’ FROM dual CONNECT BY ROWNUM <= 300 UNION ALL

SELECT ‘END;’ FROM dual;

  1. Copy/Paste the result into a new editor window

  2. Trigger picklist-dropdown.

  3. Wait

The last time I tried it, I got an AV. ELF available if required.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

ELF sent offline as requested.

I’m not able to reproduce the AV, but the performance when Available Identifiers are included in Code Insight results is terrible as the size of the source increases. This is fixed for next beta.

Thanks,

Michael

On 12/17/2013 05:29 AM, Peter Lang wrote:

12.5.0.8 Picklist-dropdown - Performance

Thread created by Peter Lang
When working with larger documents, picklist-dropdown cannot be used any more with the new beta.

Reproduction:

  1. Generate Test-Procedure like this:

SELECT ‘DECLARE t NUMBER; BEGIN’ FROM dual UNION ALL

SELECT ‘t := dbms_utility.get_time();’ FROM dual CONNECT BY ROWNUM <= 300 UNION ALL

SELECT ‘END;’ FROM dual;

  1. Copy/Paste the result into a new editor window

  2. Trigger picklist-dropdown.

  3. Wait

The last time I tried it, I got an AV. ELF available if required.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Thank you Michael, can’t wait to get the new beta :wink:

We are planning to release another beta tomorrow… hang tight. :slight_smile:

From: Peter Lang [mailto:bounce-PeterLang@toadworld.com]

Sent: Wednesday, December 18, 2013 9:57 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] 12.5.0.8 Picklist-dropdown - Performance

RE: 12.5.0.8 Picklist-dropdown - Performance

Reply by Peter Lang

Thank you Michael, can’t wait to get the new beta :wink:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.