database design

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I got a page which allow candidate to type in their previous working experience,
I let user to choose the start date and end date and then system will automatically
calculate the total experience in years and months.

So when the I need to save the data, should I save the generated total experience?

Some of my friends said I should not store the total experience in database, due to the total experience is based on the start date and end date.

First I was think about if we don't store the total exp, when the time come to search, Let say I want to search for a candidate which has total experience equals to 10 years,
I have to use mysql to do the calculation, I was wonder whether it will slow down on the select query?

if I got millions row in the database? will it affect the performance?

Your Answer:

Login to answer

Other forums

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

Can't get the unicode character
I'm trying to get some text from various parts of a file. I have converted the file to hex (bin2hex)

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const