How much does LiteSpeed for SQL Srver compress BLOBs or JPEG files? (32293)

How much does NetVault LiteSpeed compress BLOBs or JPEG files?

JPEG files are already highly compressed. And once something is compressed, it's unlikely you'll get additional compression. Depending on how much other data exists in the database, you might still see good overall compression, but if a majority of the data is in the JPEG files, then LiteSpeed data compression may not help much.

What we do recommend is customers  with binary data use Fast Compression at Compression level 1 (or higher if there is more non-JPEG compressible data in the database). Fast Compress reduces backups through its smart differential backup process and doesn't care if the data is compressible or not. You're likely to see an additional 70-85% reduction in backup footprint simply by moving to Fast Compression over nightly, full backups, and you won't have to back up all the JPEG files every night.