Hi Martin, Zeiler, Martin schrieb am 22.02.2013 13:53:
yes, you are right. This would be the easiest way. But I'm not very happy with this, because every year 10,000 students are leaving our university and all would produce empty entries.
I'm not very familiar with databases. Will we run into performance problems, if there are so many new entries every year?
TBH I can't seriously tell. Usually a MySQL table can hold a million records before things become slower, a table with 90.000 x 8 nulled fields (9 years nulled students) shouldn't be too slow. Otherwise you might want to write a little script updating all database references from the deleted users to a single dummy user for this case? You will have to gather in depths database knowledge about OTRS for this case. What is about OTRS built in archiving mechanisms? I haven't read into this. Regards, Henning