Re: How to Delete Customer?
Henning Heil <[email protected]>
| Newsgroups | gmane.comp.otrs.devel |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev