www.webdeveloper.com
Results 1 to 2 of 2

Thread: MySQL database - Profil - How to manage it ?

  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Question MySQL database - Profil - How to manage it ?

    Hello,

    I will build a script where user whill have a profil.
    This profil will have many fields.

    I thinks that there is two way to manage it :

    - A table profil with many columns (one columns by option)
    - A table like wordpress options (a systèm of key - value)

    The second option will be more scalable : if i add a profil data, i won't have to add a column ... it will only create a new "key".

    But wich solutions seems to be the best solution ?
    For table size / code optimisation.
    Which one will you choose ?

    Thanks
    Phil

  2. #2
    Join Date
    Jun 2008
    Posts
    30
    Option 1 will have better database performance. Unless you plan on adding a lot of fields on the fly I would stick with option 1.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles