On Tue, 22 Mar 2005, Martin Edenhofer wrote:
We also was thing about a reference table for ticket free text attributes. The only reason because we implemented ticket free text attributes this way is because of the performance of complex searches and a lot of ticket (> 1.000.000).
We tried different ways and the current one was the way with the best performance (of course a reference table whould be elegant way).
Which brings up the problem with a lack of foreign key support in MySQL's MyISAM tables. I'm not sure if this is in the works for MySQL 5.0, but it's available in the InnoDB table format as well as PostgreSQL (and just about any other "real" RDBMS). These really need to be utilized in OTRS 2.x. I don't see why existing tables can't be migrated over to InnoDB easily. This would allow us to move all these hardcoded data types (attachments, freetext, etc) to "reference tables". -- Jason Dixon 301.286.8635 voice NASA / Goddard Space Flight Center jason@nccs.nasa.gov AMTI, Inc. Building 28, Room S212 Code 931