Toad World® Forums

TOAD-SS 5.0.0.444 takes a long time to open a new sql editor


#1

I have this odd case when for a certain connection Toad takes a long time to create a new script or to switch from another connection to this connection. I checked the database and it doesn’t execute anything.

Has anyone seen something like this? Any suggestions?

Thanks

Message was edited by: costab


#2

Hi,
We aware of this issue. We are trying to improve this on every release. And from our perspective we have some progress here.

So I want to know your environment to be sure that this is not Toad limitation and so on:

  1. Does it actual for one particular server connection? It is reproducible every time?

  2. How much active connection do you have at the time of viewing this issue?

  3. What is the script size you are switching to?

  4. your operation system?

  5. Server versions?
    For the last two questions support bundle would be enough.
    Thanks!


#3

Alex FYI !!!

I am using a Windows 7-64 Prof 4gb of memory with Toad-SS 5.0.0.444 and I can
connect to any of my 20 server without a wait if there are no network issues and
I can load a 1500 line script in TWO seconds.

Switching that editor session to a different open connection takes less than 1
second.

I usually have 5 editor session open, of various sizes and I am not having a
switching issue at all .

Execution of a script is usually dependent on the server and where it is in the
VMWare environment (Active or passive).

Hope this helpsl

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#4

Alex FYI !!!

I am using a Windows 7-64 Prof 4gb of memory with Toad-SS 5.0.0.444 and I can
connect to any of my 20 server without a wait if there are no network issues and
I can load a 1500 line script in TWO seconds.

Switching that editor session to a different open connection takes less than 1
second.

I usually have 5 editor session open, of various sizes and I am not having a
switching issue at all .

Execution of a script is usually dependent on the server and where it is in the
VMWare environment (Active or passive).

Hope this helpsl

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#5

Hank, thanks for the information - sounds cool!
Let’s wait input from costab.

BTW, Costab, what TSS version you are talking about - 5.0 or previous 4.6, 4.5?


#6
  1. Yes. Yes.
  2. Sorry, I don’t understand your question.
  3. Small scripts, under 100 lines. Lately it doesn’t do it anymore though. I connect now using SQL server authentication.
  4. Windows 7 64 bit
    5.MS SQL Server Developer Edition, 10.0.2531.0, it runs on Windows XP, 5.1 (2600) SP3, collation SQL_Latin1_General_CP1_CI_AS.

Toad version 5.0.0.444.

Please note that it does it only on this workstation. Other servers were fine.

Message was edited by: costab


#7

Costab,
sorry, bu we can’t reproduce this on our side on 5.0.0.444 build for SS 2008. Unfortunatelly I have no SS 2008 on XP - it located on Windows Server 2003 or 2008. But I don’t think it could be the root of the issue.

As I understand it reproduces for the one particular server only, right?
Do you see these difficulties right away after launching TSS or ofter some period of time (and performing some actions)?


#8

The only other issue I have noticed is when I right click on a user defined
function (in a SELECT statement) and select “Alter Function in
Editor” I get an error report.

Norm M. Zastre

(d) 780.702.6229

(f) 780.484.9413

© 780.965.7240

(t) 800.661.7972

(e) norm@hcl.ca

(w) http://www.hcl.ca

This message (and any associated files) is intended only for the use of
toadss@yahoogroups.com and may contain information that is confidential, subject
to copyright or constitutes a trade secret. If you are not
toadss@yahoogroups.com you are hereby notified that any dissemination, copying
or distribution of this message, or files associated with this message, is
strictly prohibited. If you have received this message in error, please notify
us immediately by replying to the message and deleting it from your computer.
Messages sent to and from us may be monitored. Any views or opinions presented
are solely those of the author Norm M. Zastre and do not necessarily represent
those of the company.


#9

Could you please send the screen shot to be sure about identifying the issue?

regards,

Alexander