Hi all, I have to get OTRS to work with a web-based asset register. Particularly, we need to the ability to assign each OTRS ticket to an asset. My approach has been to stuff the TicketFreeKey1 and TicketFreeText1 with AssetIDs from our asset database from within Config.pm... .... $Self->{"TicketFreeKey1"} = { 'AsssetID' => 'AssetID', }; .... # connect to asset DB using DBI while( $resptr = $rs->fetchrow_hashref() ) { $Self->{"TicketFreeText1"}{ $row->{"AssetID"} } = $row->{"Desc"} ; } .... The trouble is that with 2000 rows in the table, there is a huge overhead on every page hit for what is only needed on a few entry screens. Can anyone please suggest a better place to put this code so that it only has to run once for each users session, and where the variables $Self->{"TicketFreeKey1"} and $Self->{"TicketFreeText1"} can still be 'seen' in the necessary pages? Many thanks! Nigel