• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

j4kp07 on 07/30/10

Tagged

mysql text json long blob Postgresql serialize nosql

Versions (?)

07/30/10 11:52am

 / Published in: SQL

 

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

SELECT AVG(LENGTH(body)) FROM DATA vs SELECT AVG(LENGTH(COMPRESS(body))) FROM DATA

Report this snippet   Tweet