Toad World® Forums

Slow Replace in Editor


#1

Hi,
i am rewriting some OWB packages. I suppose you know how the code from OWB package looks like, its terrible.

First step is that I copy batch command, and then I remove quotation marks (char ") using toad replace command (CTRL+R).
I choose to replace string " to nothing, no regular expression options, and for one simple comand (about 150 lines of code) it takes about 30 seconds (version 12.7.0.39 32bit).

In version 12.5.0.99 same replace, same options, it takes about 3 seconds.

Sample code added as attachment to this post.
Sample.sql (9.25 KB)


#2

Robert,

Can you zip and send me your user files folder to
michael.staszewski@quest.com?

Thanks,

Michael

On 02/05/2015 03:58 AM, Robert Mackovik wrote:

Slow Replace in Editor

Thread created by Robert Mackovik
Hi,

i am rewriting some OWB packages. I suppose you know how the code from OWB packege looks like, its terrible.

First step is that I copy batch command, and then I remove quotation marks (char ") using toad replace command (CTRL+R).

I choose to replace string " to nothing, no regular expression options, and for one simple comand (about 150 lines of code) it takes about 30s (version 12.7.0.39 32bit).

In version 12.5.0.99 same replace, same options, it takes about 3 seconds.

Sample code added as attachment to this post.

Attachments:

Sample.sql

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.


#3

It’s not just him. I tested his sample script in the latest beta and got the same result.

From: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]

Sent: Thursday, February 05, 2015 10:58 AM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Slow Replace in Editor

Re:
Slow Replace in Editor

Reply by Michael Staszewski

Robert,

Can you zip and send me your user files folder to
michael.staszewski@quest.com?

Thanks,

Michael

On 02/05/2015 03:58 AM, Robert Mackovik wrote:

Slow
Replace in Editor

Thread created by Robert Mackovik

Hi,

i am rewriting some OWB packages. I suppose you know how the code from OWB packege looks like, its terrible.

First step is that I copy batch command, and then I remove quotation marks (char ") using toad replace command (CTRL+R).

I choose to replace string " to nothing, no regular expression options, and for one simple comand (about 150 lines of code) it takes about 30s (version 12.7.0.39 32bit).

In version 12.5.0.99 same replace, same options, it takes about 3 seconds.

Sample code added as attachment to this post.

Attachments:

Sample.sql

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.

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.


#4

I have the same problem.


#5

We can reproduce this in house now, thanks.

On 02/05/2015 03:56 PM, drbubo20 wrote:

RE: Slow Replace in Editor

Reply by drbubo20
I have the same problem.

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.


#6

This was a good one. It’s been fixed for next beta.

Thanks,

Michael

On 02/05/2015 03:58 AM, Robert Mackovik wrote:

Slow Replace in Editor

Thread created by Robert Mackovik
Hi,

i am rewriting some OWB packages. I suppose you know how the code from OWB packege looks like, its terrible.

First step is that I copy batch command, and then I remove quotation marks (char ") using toad replace command (CTRL+R).

I choose to replace string " to nothing, no regular expression options, and for one simple comand (about 150 lines of code) it takes about 30s (version 12.7.0.39 32bit).

In version 12.5.0.99 same replace, same options, it takes about 3 seconds.

Sample code added as attachment to this post.

Attachments:

Sample.sql

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.