AnsweredAssumed Answered

database design question

Question asked by LiemDo on Mar 8, 2011
Latest reply on Mar 8, 2011 by philmodjunk

Title

database design question

Post

Hi everyone,

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

Liem Cry

Outcomes