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
Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
126 Like 17 Dislike
Previous forums Next forums
Other forums

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.

So this would write 2232 a

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Loosing changed contents when used FM REUSE_ALV_GRID_DISPLAY
Hi,

I have used FM REUSE_ALV_GRID_DISPLAY in my program as below.

CALL FUNCT

Any Good MMORPGs you've played?
I'm about to have ALOT of free time on my hands (finished highschool) and I need something to fill t

News script
Hi ...

I am not sure if this is the rite place to post this but if its not sorry

i am

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

PHP Multiples of 2, Show posts...not working (wordpress)
I have been using this code to show div.example with 6 li columns inside it, each li is a post with

noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),

a u

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash