How to store Markdown comments How to store Markdown comments php php

How to store Markdown comments


Store both. It goes against the rules for database normalization, but I think it's worth it for the speed optimisation in this case - parsing large amounts of text is a very slow operation.

You only need to store it twice, but you might need to serve it thousands of times, so it's a space-time trade-off.


Store the original markdown and parse at runtime. There are a few problems with storing the converted version in the database.

  1. If user wants to edit their comment, you have to backwards convert parsed into original markdown
  2. Space in database (always go by the rule that if you don't need to store it, don't)
  3. Changes made to markdown parser would have to be run on every comment in the database, instead of just showing up at runtime.


Just render the Markdown to HTML at runtime.

If your site runs into performance issues, the Markdown will be one of the last things you'll look into tweaking. And even then, I doubt it'll make sense.

Just take a look at the realtime JavaScript renderer that SO uses. It's fast.

Edit:Sorry, I should've been more clear. I meant just render in PHP. You'll save yourself a lot of headache -- and you probably have more important things to worry about.