Compressing History Database

Database

Compressing History Database

After every 4 or 5 queries and before the next one displays the results, I get the message "Compressing History Database..." which runs for about a minute and slows me down drastically. How do I turn off the compression (assuming that's my best bet to improve performance)?

This problem just started happening within the last couple of weeks.  My history DB is stored on a netword drive so I don't know if that's causing it to slow as well?

your help is appreciated! thanks!

2 REPLIES
Teradata Employee

Re: Compressing History Database

Have you tried running "Compact History" under "Tools" manually to see if it will stop trying to do it automatically. How big is your query history database?

Re: Compressing History Database

I appreciate your suggestion, thanks, however it didn't fix the problem. I ran a manual compression as you suggested and it automatically compressed again on the the very next query. I only have 225 queries in my history.

Is there a way to turn the auto compression of the history database off?