Say I'm making a web app which will hold a lot of data. If a user chooses to delete something, would you delete the row or use a field to mark that it's been deleted?

Deleting the row will keep the size of the table down and will mean I'm not storing data I don't need but just marking the row deleted will mean nothing is ever really lost, even if the end user can't get it back themselves.

Is there a best practice for situations like this?

__________________
Free CSS Tutorials

You really haven't provided any useful information, what type of system is this? Why would you want to undelete a row? Do you think that the situation would often present itself?

__________________

I wasn't really thinking of a specific system, I was just wondering what people tend to do in general and why they do it so that I can get a better idea of when I should use each method or if people have a totally different method I haven't thought of.

__________________
Free CSS Tutorials

It depends on the type of data you are storing. If you want to keep records of that row, you obviously would not want to delete it. But if upon deletion it will never be needed again, delete it.

__________________

Like VI said, it depend on the system. I know some people in the camp of you never ever delete records.

One thing you can do is make a deleted field.If the said field = 1, it is effectively deteleted in thze users eyes. Remember you will then have to make display queries have a where clause that doesn't display those rows.

__________________
Ryan | Blog | Twitter