Toad World® Forums

TOAD 13 is much slower than the previous version 12.


#1

I notice this especially when managing the packages in the schema browser. It takes about 30 seconds and more before the source code is displayed.

Changing the tables in the schema browser takes much longer than with the previous version.

It feels like it’s a debug version.


#2

Turn on spool SQL. Do you see any extra queries, or are queries taking longer than usual?


#3

I have already seen the SQL Spool Output, there are no extra queries to recognize.
It only takes forever until the source code is displayed. I guess it’s the code analysis, but why?


– Session: XXXXXXXXX
– Timestamp: 15:14:33.800
Select TEXT
from SYS.USER_SOURCE
where NAME=:name
and TYPE=:type
order by LINE;
:name(VARCHAR[10],IN/OUT)=‘PA_ARTIKEL’
:TYPE(VARCHAR[12],IN/OUT)=‘PACKAGE BODY’


– Session: XXXXXXXXX
– Timestamp: 15:14:36.173
Select created, last_ddl_time, object_id, status
from sys.user_objects
where object_name = :nm
and object_type = :t;
:nm(VARCHAR[10],IN/OUT)=‘PA_ARTIKEL’
:t(VARCHAR[12],IN/OUT)=‘PACKAGE BODY’


#4

Wow, yes something is going on. For me there is only about 1/10th of a second between those two queries.

Not much has changed in the Schema Browser code for Toad 13, so I’m not sure what the cause is.

Can you zip up and send me your user files folder? Send to john.dorlon@quest.com.

-John


#5

Hello,

you need the contend of

%USER%\AppDate\Quest Software\Toad for Oracle\13.0\

?

Mit freundlichen Grüßen

Stefan Graf

Prokurist

common solutions GmbH & Co. KG

Telefon: +49 234 5885 – 102

Fax: +49 234 5885 – 191

www.levitaio.de

www.storelogix.de

www.common-solutions.de

Home24 nutzt storelogix aus Überzeugung:


common solutions GmbH & Co. KG, Wasserstrasse 223, D-44799 Bochum, Germany

Amtsgericht Bochum HRA 4381 - Geschäftsführer: Roger Kirchhoff, Patrick Zimmermann - Persönlich haftende Gesellschaft: common solutions Verwaltungs-GmbH, Wasserstr. 223, D-44799 Bochum - Amtsgericht Bochum HRB 7443

Von: John Dorlon bounce-jdorlon@toadworld.com

Gesendet: Montag, 7. Mai 2018 15:57

An: toadoracle@toadworld.com

Betreff: RE: [Toad for Oracle - Discussion Forum] TOAD 13 is much slower than the previous version 12.

RE: TOAD 13 is much slower than the previous version 12.

Reply by John Dorlon

Wow, yes something is going on. For me there is only about 1/10th of a second between those two queries.

Not much has changed in the Schema Browser code for Toad 13, so I’m not sure what the cause is.

Can you zip up and send me your user files folder? Send to john.dorlon@quest.com.

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#6

Yes, that’s it. Thank you.


#7

Hello,

hier are the datas.

I assume that you treat the data confidentially, because I can not fully assess whether there is also personal information.

Mit freundlichen Grüßen

Stefan Graf

Prokurist

common solutions GmbH & Co. KG

Telefon: +49 234 5885 – 102

Fax: +49 234 5885 – 191

www.levitaio.de

www.storelogix.de

www.common-solutions.de

Home24 nutzt storelogix aus Überzeugung:


common solutions GmbH & Co. KG, Wasserstrasse 223, D-44799 Bochum, Germany
Amtsgericht Bochum HRA 4381 - Geschäftsführer: Roger Kirchhoff, Patrick Zimmermann - Persönlich haftende Gesellschaft: common solutions Verwaltungs-GmbH, Wasserstr. 223, D-44799 Bochum - Amtsgericht Bochum HRB 7443

Von: John Dorlon bounce-jdorlon@toadworld.com
Gesendet: Montag, 7. Mai 2018 16:31
An: toadoracle@toadworld.com
Betreff: RE: [Toad for Oracle - Discussion Forum] TOAD 13 is much slower than the previous version 12.

RE: TOAD 13 is much slower than the previous version 12.

Reply by John Dorlon

Yes, that’s it. Thank you.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


#8

Yes, of course I will treat it confidentally. However, you posted it on Toad World rather than email direct to me. It looks like a rather fresh set of user files, so there probably isn’t much in there.

I have downloaded the files, but you might want to delete the files if you don’t want them there.


#9

I can’t reproduce any slowness with your User Files.

Are all windows in Toad slow or just Schema Browser?

Does it make any difference which database you connect to?


#10

Hello,

I can checked it on three different Oracle servers, on alle are the same.

I have made a small video.

You can see, the switch between package and package body takes about 6 seconds, and this is fast!

In other situation, toad hangs completely for a 30 seconds.

Mit freundlichen Grüßen

Stefan Graf

Prokurist

common solutions GmbH & Co. KG

Telefon: +49 234 5885 – 102

Fax: +49 234 5885 – 191

www.levitaio.de

www.storelogix.de

www.common-solutions.de

Home24 nutzt storelogix aus Überzeugung:


common solutions GmbH & Co. KG, Wasserstrasse 223, D-44799 Bochum, Germany

Amtsgericht Bochum HRA 4381 - Geschäftsführer: Roger Kirchhoff, Patrick Zimmermann - Persönlich haftende Gesellschaft: common solutions Verwaltungs-GmbH, Wasserstr. 223, D-44799 Bochum - Amtsgericht Bochum HRB 7443

Von: John Dorlon bounce-jdorlon@toadworld.com

Gesendet: Montag, 7. Mai 2018 18:04

An: toadoracle@toadworld.com

Betreff: RE: [Toad for Oracle - Discussion Forum] TOAD 13 is much slower than the previous version 12.

RE: TOAD 13 is much slower than the previous version 12.

Reply by John Dorlon

I can’t reproduce any slowness with your User Files.

Are all windows in Toad slow or just Schema Browser?

Does it make any difference which database you connect to?

To reply, please reply-all to this email.

Stop receiving emails
on this subject.

Or Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#11

Thanks for the video. Overall, my Toad is 13 is generally as fast as Toad 12 (and in a few places, faster)…but…I can reproduce some slowness on switching between package spec and body on somewhat large packages such as the ones in the APEX_0##### schema. I’ll look at this today and let you know. I just wanted to reply early because we are in such different time zones.


#12

I found a few things to optimize, and they are fixed for the first 13.1 beta, which should be available sometime in the coming days or weeks.

I am not sure that it will be 100% as it was in 12.12, but there should be some improvement over 13.0. Please give it a try if you can and let me know.

If there are other places where it is slow (besides changing nodes in SB-Packages), please give me some details or another short video.

Thanks.