Copied to clipboard

Flag this post as spam?

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

  • Puck Holshuijsen 91 posts 354 karma points
    Jul 04, 2018 @ 10:26
    Puck Holshuijsen

    Large disk usage from merchInvoiceItem

    Hi Guys,

    I am looking into why my DB is having some issues, and I came across something.

    My DB disk size is around 2400MB, half of that (1200MB) is being produced by the table merchInvoiceItem. I think it is because of the column extendedData, which is of the type ntext.

    I've done some research and calculations, and it would be better to use nvarchar(max).

    My only question is: can i change the type from ntext to nvarchar(max) without any problems? Or does anybody have tried this and encountered major problems?

    I am using Merchello 2.5.0 and Umbraco 7.5.11.

    Thanks in advance!


Please Sign in or register to post replies

Write your reply to: