Is is better to store serialized data or raw html in mysql?
Posted
by Yegor
on Stack Overflow
See other posts from Stack Overflow
or by Yegor
Published on 2010-03-12T02:21:49Z
Indexed on
2010/03/12
2:27 UTC
Read the original article
Hit count: 284
I de-normalized my database, since the application was crawling otherwise, and Im storing a list of categories for each item in the DB as a raw html version, and simply echoing it out in my design. Each category is actually a link, which is include a tag. Naturally, this is abit of a pain, especially if I want to change the look of how the category links are displayed, since I gotta update all the old cached entries.
What if I were to store this data as a serialized array instead, and simply unserialize it, and then apply formatting to it in php. Would there be a significant performance decrease over simply echoing out the raw html?
© Stack Overflow or respective owner