Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Database Cleanup View modes: 
User avatar
Kentico Legend
Kentico Legend
Brenden Kehren - 10/3/2012 11:13:24 AM
   
Database Cleanup
I've got a client with limited db space (200mb) and need to clear up some tables, does anyone have any recommendataions as to where to start? I've already cleared out the unnecessary additional site info, page templates, layouts, etc that weren't needed. Set logging to be somewhat limited (would be nice to be able to log to file system vs. db only), files are only stored in file system and versioning to be just a few major versions.

Only problem I see with versioning is if you decided to not version something any longer, the system still keeps the records in the database so they have to be manually deleted at the object level or manually in the database. I've submitted a UserVoice suggestion to change that here.

Just wondering if there was some additional areas to look into.

User avatar
Member
Member
egarrison-wte - 10/7/2012 8:11:11 PM
   
RE:Database Cleanup
If the client has limited amount of SQL storage, make sure you store images in the File System, not the Database.

Tables: CMS_EventLog, CMS_Export_Task, CMS_staging_task, CMS_AttachmentHistory

Those are the ones I would check tof cleanup.

User avatar
Kentico Support
Kentico Support
kentico_radekm - 10/8/2012 1:55:44 AM
   
RE:Database Cleanup
Hello.

Regarding storing files in the file system instead of DB, please refer to http://devnet.kentico.com/docs/devguide/index.html?files_related_settings.htm.

I agree with an advice above, with regard to how to reduce DB size. However, limit 200MB is very low and it might be causing some problems in the future. I don’t know what kind of site is your client running, but he might want to consider a changing of the environment / hosting provider, as 200MB is really poor limit these days.

Best Regards,
Radek Macalik