poirot Posted June 17, 2006 Share Posted June 17, 2006 HiI was making a poll thing, but I dont know what is the best way to store data... Idea #1:Table "polls": fields: poll_id, poll_question, poll_options, poll_options_num_votesbeing poll_options and poll_options_num_votes serialized arrays.Idea #2:Table "polls":fields: poll_id, poll_questionTable "poll_options":fields: poll_id_from, option_text, option_votesConsidering a that I may have potentially thousands of polls, thus maybe up to tens of thousands of options, what is the best option?Thanks [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] Quote Link to comment https://forums.phpfreaks.com/topic/12243-table-structure-help-needed/ Share on other sites More sharing options...
fenway Posted June 18, 2006 Share Posted June 18, 2006 Closer to idea 2, for sure -- no serializing in a single column. And 1000s of records is not a problem at all. Quote Link to comment https://forums.phpfreaks.com/topic/12243-table-structure-help-needed/#findComment-46913 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.