Takes a long time to open TIC server from TDP due to toad_auto_script_executions table being too large (4244503)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Takes a long time to open TIC server from TDP due to toad_auto_script_executions table being too large
Description

When trying to connect to the TIC server from TDP, it is a taking a long time. This is due to the toad_auto_script_executions table being too large. Is there a way to trim this table down to improve perfomance upon connection?
Resolution

WORKAROUND:
Attached are trim table scripts. Run the scripts with root user through 3566 port to trim the automation script execution history. Run the scripts provided regularly as a workaround until the enhancement is released.

The parameter of 'CALL trim_automation_execution(20)|' can be changed. That parameter means the number of latest records for each automation script that you want to keep. So, with what is above, it means it will keep the latest 20 execution records for each automation script.

It's better to back up data before running the script. Click here for a link to a Knowledgebase article that explains how to backup.

STATUS:
This enhancement was implemented in Toad Intelligence Central 5.0.8. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

TIC-11812
Attachments

trim_automation_execution
Additional Information

This enhancement was create to auto trim that table regularly in a future version.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title