Serialize an array to store it versus create a specific table in mysql

Question

I want know what solution is more efficient (or know another better solution of course). If I have a website where any user can leave a comment for each post, what will be the better solution?

Serialize an array with all comments for that post in a column of database (I don't know if it is possible that two users leaving a comment at the same time can lead to data loss)

Or maybe is better the following:

Creating a specific table called comments, where I have an unique id for each post and other unique id for each username

I read that some people don't like use the serialize function, but I don't know if it is a good idea or not their use

Create a table. It's better scalable and maintainable than using a serialized array. — Charlotte Dunois
– Charlotte Dunois, Commented Jan 27, 2016 at 17:06
Ok, thanks for your reply @CharlotteDunois Do you think that the efficiency of the database is maintained with two ids for each row? Or can I do another thing to improve the efficiency? — Kevin Gravell
– Kevin Gravell, Commented Jan 27, 2016 at 17:11
Tables are the better route. Serializing is best when there are large amounts of data for a single record and when you're not asking for the data constantly. — Tuesdave
– Tuesdave, Commented Jan 27, 2016 at 17:11

Dmitry · Accepted Answer · 2016-01-27 20:54:09Z

1

Table. Comments table with relation to your Posts And no alternatives for it. Create, update, delete actions for specific comment and search at all becomes painful using serialization into single field.

answered Jan 27, 2016 at 20:54

Dmitry

1321 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Serialize an array to store it versus create a specific table in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related