Advanced Search

MySQL Blob Compression performance query

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT AVG(LENGTH(body)) FROM DATA vs SELECT AVG(LENGTH(COMPRESS(body))) FROM DATA

URL: http://www.mysqlperformanceblog.com/2008/01/11/mysql-blob-compression-performance-benefits/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.