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

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Delete Client 066 Earlywatch
Hi all,

in former times client earlywatch was required for SAPs remote access to SAP inst

Update not working ... please help
Hi,

I am trying to update a row using an edit form by passing id of the row .. but it is not

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