Efficient way to store html element in sql

Question

I'm saving contents of a particular div in mysql database as html elements. So the html elements content includes many elements such as:

<div id="div0" class="box" style="z-index: 2; width: 1689px; height: 1013px;">
   <img style="margin: 0px; position: relative; display: block; height: 550px; width: 638px; top: 0px; left: 0px;">
</div>

Is there any way to reduce the data for efficiently storing in mysql database.

Such as any php or javascript functions to compress before saving to db.

Is there a reason why you're looking to compress it? Are you having storage or performance issues? — Fosco
– Fosco, Commented Feb 1, 2012 at 17:37
@Fosco: maybe he's storing really large fragments and they don't fit :-) — Sergio Tulentsev
– Sergio Tulentsev, Commented Feb 1, 2012 at 17:38
You could always base64_encode() the string to compress it slightly. It may not make much of a difference though in length. — Tim Withers
– Tim Withers, Commented Feb 1, 2012 at 17:40
@Tim I don't think base64_encode will help much on this ;) — DerVO
– DerVO, Commented Feb 1, 2012 at 17:46
@Fosco: The field is too large and I think its not best practice to store too large data in single field. I'm storing a html prototype inside a div (the application is a wire frame builder ) — joHN
– joHN, Commented Feb 1, 2012 at 17:52

Marc B · Accepted Answer · 2012-02-01 17:38:01Z

5

Why compress? Disk space is cheap, and storing it in a compressed (e.g. gzip) format will just cost you CPU time to decompress/recompress each time.

As well, once you compress the data, it becomes an opaque binary blob to the DB, and you lose any ability to search that text via substring/fulltext.

answered Feb 1, 2012 at 17:38

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DerVO · Accepted Answer · 2012-02-01 17:42:03Z

4

You could compress the string before saving it to the database using gzcompress()/gzuncompress() PHP functions or you can do it with mysql using COMPRESS()/UNCOMPRESS() in your queries - but unless you have very much data I would not recommend this.

You win some harddisk space, but you lose a lot of transparency (search, edit, convert, migrate...)

answered Feb 1, 2012 at 17:42

DerVO

3,6791 gold badge27 silver badges27 bronze badges

1 Comment

joHN Over a year ago

I used gzcompress along with the BLOB datatype for db fields, Details

Collectives™ on Stack Overflow

Efficient way to store html element in sql

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related