CODEWITHSUNDEEP
mysqldatabase
Valentin Emil Cudelcu
Valentin Emil Cudelcu

Reputation: 679

Mysql store HTML code

If I want to store HTML code to a database, is better to add one row with big HTML code or more rows with smaller HTML code?

In my app, I can edit the code in both ways, so don't really need more rows, but maybe is faster or more effective having more rows and smaller HTMl code.

What is your opinion? Thanks you.

HTML Code Example:

<div class="row">
  <div class="col-sm-12">
    <section data-type="component-text">
      content
    </section>
  </div>
</div>
<div class="row">
  <div class="col-sm-6">
    <section data-type="component-photo">
      content
    </section>
  </div>
  <div class="col-sm-6">
  <section data-type="component-video">
    content
  </section>
  </div>
</div>

The code is generated by a plugin. This is only an example created by me.

Upvotes: 0

Views: 169

Answers (1)

Achooo
Achooo

Reputation: 107

Answer: It depends on your querying needs.

Efficient querying is an extensive topic focused on design and algorithms. It depends on the size, type and structure of the data you have.

If you just need to store all the HTML and get it back, you could simply store as much per block.

If you need specific lines of HTML per query then each block with the necessary content is a good idea!

I hope this helps.

Upvotes: 2

Related Questions