Symphony.

Hey guys,

Someone can explain me why the Symphony database for Sections/Entries is so fragmented? (It’s not a critic is a really doubt)

For example:

I create this Section:

Name: Members

Fields:

• First Name
• Last Name
• Email
• Country
• Username
• Password

Why the database table isn’t like this:

Table Name: sym_section_members

Table Structure: Table image

I’m sure someone could explain in much more detail, but the database is normalized in order to make the data models you create more flexible. For instance, every symphony field can have more than one actual data field attached to it, and every entry has other metadata attached to it also I believe. IT is essentially a small sacrifice in performance for a large gain in flexibility.

see Nick’s recent response

Perfect aswers by ashooner and nickdunn.

@czheng, sorry, I screwed up not searching it right!

Thanks!