MySQL Blob Compression performance query - SQL Snipplr Social Repository

Revision: 29493

at July 30, 2010 11:52 by j4kp07

Initial Code

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

Initial URL

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

Initial Description

Initial Title

MySQL Blob Compression performance query

Initial Tags

mysql, text, json

Initial Language

SQL