Our Oracle DBA noted what he thought was a design flaw yesterday - on retrievals, the SQL isn't binding any of the variables (like form ID), so it's having to re-fetch each of those each time, instead of having it locally cached like a server variable. That causes the searches to take FAR longer than they otherwise would. Rick _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma Sent: Tuesday, June 19, 2007 5:35 AM To: [email protected] Subject: Re: CMDB Performance Issue - Heads Up out there ** Roger.... interesting.... how many rows are in your BMC:CORE:BMC:BaseElement and BMC:CORE:BMC_BaseRelationship table? Are you on Oracle or SQLServer? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Roger Justice Sent: Monday, June 18, 2007 4:49 PM To: [email protected] Subject: Re: CMDB Performance Issue - Heads Up out there ** ITSM 7 CMDB 2.X each computer had 100-200 software items related and the loading of the individual computer and the selection of the related items tab was 1-3 seconds. Maybe it was improved. _____ See what's free at AOL.com <http://www.aol.com?ncid=AOLAOF00020000000503> . __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
