I have added over 200 additional fields with workflow associated to each field on the 7.0.3 Help Desk form for one customization (not the best solution for the project but it worked) and had no difficulty with retrieval of data or db overhead issues. As long as your dba's know how to manage their objects there should not be any difficulty. I would suspect that with the ability to assign private queues in 7.5 to your ITSM modules it will be even less of a burden to the database.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Coleman, Gavin Sent: Friday, October 16, 2009 4:14 AM To: [email protected] Subject: Number of Fields on HPD:Help Desk ** Hi List - I'm wondering if anyone can help me with a problem we're having. We're in the process of customising ITSM 7.5 for use across the whole of our company. We are a managed service company providing support for many customers. This will result in significant numbers of Incidents being raised. As part of our customisation we're adding optional fields on the HPD:Help Desk form. This form currently has 342 data holding fields. Our DBA team are concerned that the number of columns this corresponds to will cause significant DB overhead to pull back records from the HPD:Help Desk form. My manager has suggested the following solution - create a new form that will hold all these data holding fields. This form will have a one-to-one relationship with the corresponding HPD:Help Desk record. We can then pull the data from these fields back to the HPD:Help Desk record into display only fields. Technically I can see that this would work - there are a few problems with comparing DB values of the Display Only fields, but nothing that can't be sorted relatively easy. There are problems with users wanting to search on these fields, but again this is relatively easy to sort - join forms. My questions are several? 1. Are the DBA guys right to be concerned about the number of columns? 2. Has anyone ever attempted the solution suggested? 3. Are there any other problems with this solution? 4. If we implement this, would that reduce our DBA overhead? ITSM 7.5 Windows 2008 Oracle 10.2.0.4.0 - 64bi - Probably moving to Oracle 11 by the time we go live though. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: [email protected] W: www.computacenter.com ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
