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

Filed under:
|
|

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

Related posts about caching

Related posts about serialization