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?
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
is working on a reply...