Toad World® Forums

Toad Performance is Poor on Database with a large amount of Objects

I work in a database with a large amount of objects and Toad performance is poor.

See the following for reference.

Object Type

Count

Default or DEFAULT constraints

35

Scalar functions

1

Inlined table-functions

1

PRIMARY KEY or UNIQUE constraints

172,050

Stored procedures

64

System tables

45

Table functions

2

Triggers

19,039

User tables

229,710

Views

6,996

Any suggestions on how to improve performance?

It sounds more like an issue of size than it is number of objects. Is the poor performance a total system issue or a query issue?

From: jarledge [mailto:bounce-jarledge@toadworld.com]

Sent: Wednesday, January 24, 2018 10:58 AM

To: toadss@toadworld.com

Subject: [Toad for SQL Server - Discussion Forum] Toad Performance is Poor on Database with a large amount of Objects

Toad Performance is Poor on Database with a large amount of Objects

Thread created by jarledge

I work in a database with a large amount of objects and Toad performance is poor.

See the following for reference.

Object Type

Count

Default or DEFAULT constraints

35

Scalar functions

1

Inlined table-functions

1

PRIMARY KEY or UNIQUE constraints

172,050

Stored procedures

64

System tables

45

Table functions

2

Triggers

19,039

User tables

229,710

Views

6,996

Any suggestions on how to improve performance?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for SQL Server Forum
notifications altogether.

Toad for SQL Server - Discussion Forum

Flag
this post as spam/abuse.

The database works fine. Toad seems to choke, pause, and start counting tables, indexes, etc.

My apologies. Unfortunately that is outside of my knowledge base. I could get into the whole “what are you system specs/settings/etc.” dialogue but that’s not going to help. I’ll have to leave this one to the software pro’s.

From: jarledge [mailto:bounce-jarledge@toadworld.com]

Sent: Wednesday, January 24, 2018 11:44 AM

To: toadss@toadworld.com

Subject: RE: [Toad for SQL Server - Discussion Forum] Toad Performance is Poor on Database with a large amount of Objects

RE: Toad Performance is Poor on Database with a large amount of Objects

Reply by jarledge

The database works fine. Toad seems to choke, pause, and start counting tables, indexes, etc.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for SQL Server Forum
notifications altogether.

Toad for SQL Server - Discussion Forum

Flag
this post as spam/abuse.

Hi Jarledge,

We have impove Object Explorer area in new v6.9 beta.

Could you have a try new beta for performance issue?

Michael