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?

Other php-forum

problems with contact forms that are only protected against SQL injections
What could be a potential problem with contact forms that are only protected against SQL injections

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

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

Access database inside of a validation class
Hello,

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

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

want a code for uploading and downloading
i m trying to upload and download to my site..i need upload and download code ...i use a code for up

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

I need to increse 6hours more, and i don't know how???
I need to increse 6hours more, and i don't know how???
<tr>
<t

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with