Variable Database

Forum|Forum|16 years ago
January 18, 2010
1 reply
943 views

Currently running a very old version of ColdFusion (5 on a Server 2000 SP4 OS, with SQL 2000 db) and I have a problem with size on one of the variable databases (named CFIISVariables in my case and has 2 tables CDATA and CGLOBAL). It is nearly 29GB in size and currently eating up nearly all my disk space. Is there a way for me to reduce the size of the database aside from the normal shrink in SQL? It looks like data is in there from when the website was started in 2003.

Thanks

This topic has been closed for replies.

Correct answer Adam Cameron.

Those are just your client variables. I'd say it would be safe to delete all rows that are older than... ooh... a month?

There should be a setting in CFAdmin to do this for you automatically. It should be switched on.

--

Adam

A

Adam Cameron.Correct answer

Inspiring

Those are just your client variables. I'd say it would be safe to delete all rows that are older than... ooh... a month?

There should be a setting in CFAdmin to do this for you automatically. It should be switched on.

--

Adam

B

b471code3Author

Participant

Right now I think there are 2.2 million records in each table. I don't have a problem running a delete statement on the tables but don't see where it would do this in the Admin site. Any ideas on where to start or set this?

Thanks

A

Adam Cameron.

Inspiring

On CF5? No, can't remember. But in CF8 it's a setting on the Client Variables tab in CFAdmin to set the purge interval. I have no reason to think it's any different in CF5, but have not seen CF5 for about eight years.

You could always consult your documentation (or Google some up)...

--

Adam

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded