Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ast35 23 posts 44 karma points
    May 10, 2012 @ 18:32
    Ast35
    0

    Questions about dealing with large database

    OK, I'm been making changes to a site which I have now finished, but we are running into issues with quite a large database (about 270Mb).

    I wonder if it might be to do with the fact that I was intending to copy the home page alone and accidentally copied all its child documents as well. I deleted them, but I am wondering if them are still around.

    However, there aren't [i]that[/i] many pages in the site, and I'm quite surprised that this would have such an effect.

    But anyway, the database is too large at this point and I need to deal with it without breaking the site.

    I have access to the database through a web based interface.

    The largest tables are :

    cmsContent - 951 rows
    cmsContentVersion - 2147 rows
    cmsDocument - 1876
    cmsPreviewXml - 1664 rows
    cmsPropertyData - 48759 rows
    umbracoLog - 275897 rows
    umbracoNode - 1058 rows

    So yes, I need to get it below 200Mb.

    I'd appreciate any assistance with this matter.

    Thanks in advance.

  • Dan 1288 posts 3921 karma points c-trib
    May 10, 2012 @ 20:27
    Dan
    1

    Hi,

    Personally, I would truncate the umbracoLog table if you're not concerned about losing audit trail data.  I regularly do this for clients who don't have audit trail requirements to keep the database relatively lean.

    HTH

  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    May 10, 2012 @ 23:09
    Hendy Racher
    1

    Hi,

    How about the F.A.L.M Housekeeping package - can selectively clear the log and delete old document versions.

  • Tizer 170 posts 201 karma points
    May 14, 2012 @ 07:49
    Tizer
    0

    F.A.L.M Housekeeping package is great thanks, just knocked 100mg of my database.... I might even trim it more :)

Please Sign in or register to post replies

Write your reply to:

Draft