MySQL Forums
Forum List  »  PHP

Which is faster/better/why?
Posted by: thomas ghoreyeb
Date: May 23, 2005 07:13AM

Suppose I was creating an hr site...

I could have all the application, applicant response, and ui display info, validation and more in two tables using:

//table to store the ui fields, css layout, field default values, descriptors...

fieldid,fieldName,class,value,validation,page

// this stores the applicant response to each individual field.
applicantid,fieldid, responseValue
_____________________________________________________________
But most examples for this I see are highly relational with many tables....

//application:
applicationid,lastname,firstname,email,

//respondent:
respondentid, applicationid, lastname, firstname

//state_province
stateprovinceid stat_province_name

//country
countryid, country_name

//etc
etcid,
//and on and on...
_______________________________________

Options: ReplyQuote


Subject
Written By
Posted
Which is faster/better/why?
May 23, 2005 07:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.