All geek questions in one place

SQL Server VARCHAR (MAX) and DB size are very high

I store HTML in a database. No, this is not a dynamic web application, but a template that is stored in a database and finally printed.

This template is VARCHAR (MAX) and has an average of 700K entries (7 lac entries). The database stores about 28 thousand records, and the database size is 21 GB.

I realized that this is the "Template" column, which leads to a large database size. The size of this column in the database is about 17 GB.

Do you think I can add any compression for compression and then save this data in a database? I know this will be a small compression add-in, but I doubt it will be large.

I cannot store the database outside of SQL, as this will make sensitive data available to everyone who has permission to share files.

Any other ideas are also appreciated. (Binary, text, or something else)?

+3
source share
2 answers

SQL Server 2008 has built-in data compression that you should pay attention to.

0
source

If you need to save it, you must save it.

Are you sure you want to save it? Can't you throw away the old ones?

Secondly, isn't disk space cheaper than programmer time? Just ask.

0
source

Source: https://habr.com/ru/post/1794145/

More articles:


All Articles