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

Php If in MySql query (hiding labels if a field is empty)
Okay, I've been trying to do this for a while, and I'm finally going to ask for help so I can get th

Curly Bracket Delimeters.
I'd always believed that the starting and ending delimeters in preg_ functions had to be the same ch

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

Filtering for a phrase using pregmatch
Here is my code which looks for addresses which start with ' src=" '

Code: [Select]preg_

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

How can use this array as a key?
Say I have this array for example:


print_r($array);

Prints:
Code: [Select]Array

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