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

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

ALV List display - header width adjust
Hi,

I am using REUSE_ALV_LIST_DISPLAY for my ALV display.The width of the ALV varies for

How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them

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

Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.

We made a reverse goods movemen

MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I

Using Curl_multi for processing multiple URLs
Hi,

I am at a loss as to how to implement this. I would like to be able to automatically assi

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.