Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • 1
    [Clarification1: by 'constantly querying', I meant that we have queries which are like: '... FROM users WHERE isdeleted="0" AND ...'. For example, we may need to fetch all users registered for all meetings on a particular date, so in THAT query, we also have FROM users WHERE isdeleted="0" - does this make my point clearer?] @Adrian Commented Jul 21, 2011 at 1:10
  • Yup much clearer. :) If I am doing that, I would rather make it as user's status change, instead of looking it as physical/logical delete. Though the amount of code will not reduce ( "and isDeleted='0'" vs ' and "state <> 'TERMINATED' ") but everything will look much more reasonable, and it is normal to have different user state too. Periodic-purge of TERMINATED users can be performed too, as suggested in my previous answer) Commented Jul 21, 2011 at 3:56