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

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

PHP & Java
Hello,

can PHP code be used inside java code?

Code: <SCRIPT LANGUAGE="Java

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?

System copy error in RUN ABAP REPORT PHASE
Hi,
I am performing system copy on my test server. I have previously taken export of JAVA + A

Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume