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 90 posts 352 karma points
    Jul 04, 2018 @ 10:26
    Puck Holshuijsen
    0

    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!

    Puck

Please Sign in or register to post replies

Write your reply to:

Draft