How to make TOAD run faster?

Hi all,

I’m having a problem with TOAD being slow when it re-draws it’s window
on the screen. Sometimes it can take several seconds just to grab the edge of
the TOAD window and resize it.

I understand that TOAD is doing a lot of work under the covers, especially when
I have 8 sessions open and a couple of dozen tabs. So, my question is, what
features of TOAD are expensive in terms of resources on my PC? For example,
maybe using Unicode fonts can slow things down. There are probably lots of
features I could do without or reconfigure in exchange for better TOAD windowing
performance. Would a better graphics board help?

I’m currently running on a Core 2 CPU 6400 @ 2.13GHz and 2 GB Ram.

Any help would be appreciated because this, and the slowness of switching from
tab to tab is very frustrating when you are in a hurry to get work done.

Regards,

Mike

Is windows hitting the page file? That’s what it sounds like to me.

-John

I assume that you are referring to the Editor when you mention tabs. If you mean
something else then please ignore the following and let us know which window you
are speaking of.

Sometimes it can take several seconds just to grab the edge of the TOAD window
and resize it.

I see that this effect is more pronounced as the number of opened Editor tabs
increases. I'll take a peek and see if there is something that can be done.

I have 8 sessions open and a couple of dozen tabs

There are some improvements in place for Toad 11 that are available in the
current beta if you'd like to participate in the beta program. The Editor has a
somewhat low tolerance for many tabs in previous versions. Toad 11 should be
better. I have a folder containing 84 relatively small SQL and PL/SQL files and
can open them all in ~28 seconds. The Editor is usable in this state.

the slowness of switching from tab to tab is very frustrating when you are in
a hurry to get work done.

This is a sore spot for me because there is a way to fix this completely, but
there was little support for making the change. The change proposal was shot
down, but it is outlined in detail in an old thread on the beta forum. If you
search the beta forum at www.toadfororacle.com for "Editor resource" you should
find the thread for "Editor resource usage and efficiency poll" or something
similar to that. The site seems to be very slow and largely unresponsive at the
moment though.

In short the problem comes from the different tab styles and desktop handling.
Each tab must remember its own dock layout and that layout must be restored when
changing tabs. This takes some time. It is more efficient in Toad 11, but still
there is a delay that is more noticeable with dozens of tabs. The only way to
make it snappy is to remove the segregation of SQL, PL/SQL, and Text content and
unify them under a single tab style that uses a single desktop instance for all
Editor tabs. Until that point I think that it is unlikely that tab switching
will occur much faster than you'll see in Toad 11.

Michael

Main menu -> help -> toad advisor

This utility wil tell you if you have any toad settings set to slow things down
– read the notes it gives and double click on any entry to take you to
place to fix it

Also read these toad world posts:

http://toadworld.com/BLOGS/tabid/67/EntryId/624/Go-Toad-Go.aspx

http://www.toadworld.com/BLOGS/tabid/67/EntryId/162/Speed-Up-Toad.aspx

http://www.toadworld.com/BLOGS/tabid/67/EntryId/274/Speed-Up-Toad-Updated.aspx

http://www.toadworld.com/BLOGS/tabid/67/EntryId/135/Toad-Sometimes-Slow-on-Oracle
-10g.aspx