database design question
I have a field name answer that contains value 1 or 0 which means "Yes" and "No" respectively. I have another field named answerCalculated which uses the calculation to convert 1 to Yes and 0 to No. I placed answerCalculated on my layout.
My question is: should I store the value "Yes" and "No" directly in answer so I don't have to use answerCalculated? Which way make my program run faster especially when I have a lot of records (around 300K)? Thanks