"Adjust the indexing to match the most common queries" And then there is the poor person(s) that has to run an uncommon query.
On Wed, Feb 25, 2015 at 11:17 AM, Brittain, Mark <mbritt...@navisite.com> wrote: > ** > > Its’ all about indexing. I have a large form on a 6.3 platform that > contains over a million records and just flies. Adjust the indexing to > match the most common queries. Company, Status, Assigned Group are probably > the most common. Anything that is required and menu driven would be good > candidates. But be careful not to have too many indexes because indexes > rebuilt when a new record is inserted. > > > > Mark > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza > *Sent:* Wednesday, February 25, 2015 8:48 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: ADV: Meta-Archive Product Announcement: ITSM Archiving > > > > ** > > Absolutely agree. An RDBMS is meant for massive amounts of data “so long > as its efficiently stored and retrieved”. That’s the key factor. > > > > Else its just like storing it in an Excel sheet if one does not pay heed > to queries and the way data is retrieved. > > > > Cheers > > > > Joe > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg > *Sent:* Tuesday, February 24, 2015 5:21 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: ADV: Meta-Archive Product Announcement: ITSM Archiving > > > > ** > > Actually — I am wondering … do people agree with this fundamental > assumption that the more records the worse the performance? > > > > To me — that is only for “inefficient queries” and — for the most part - > even if you archive — you will still have a slow system. > > > > Do people agree with that??? And if so — isn’t the right solution - to > “fix the queries”. > > > > I know this — archiving "roughly doubles” the reporting headaches, > workflow headaches, maintenance headaches. > > > > -John > > > > > > > > On Tue, Feb 24, 2015 at 3:39 PM, Ben Chernys < > ben.cher...@softwaretoolhouse.com> wrote: > > ** > > Hi Folks, > > > > As enterprises have been using ITSM for some time now, they have > accumulated Incidents, Changes, and other “root requests” that are closed, > old, and can be archived. These data have slowed down searches and the > ITSM application responses. Moving these data into Archive tables speeds > up database search and retrieval from the high-use, active ITSM tables. > > > > > > *ITSM Challenges* > > > > BMC Remedy OOTB Archiving handles each table independently. In fact, an > ITSM > > Incident comprises many records in many forms — a * tree* of dependent > records. > > > > Further, if an Incident is associated with a Change that is not archive > ready, then that > > Incident too, *must* *not* be archived. > > [image: Meta-Archive for an ITSM Incident] > > *Introducing Meta-Archive* > > > > *Your Benefits* > > Software Tool House's Meta-Archive solves all ITSM Archiving challenges > and implements your archiving rules. We make it easy! Handle customers and > classes of tickets differently, add your customized forms easily — all in a > simple spreadsheet. > > Archive forms are automatically generated. Associations are checked and > reported. > > > > *Meta-Archive delivers* > > · All associations are checked before a record is archived. > > · The entire tree of records is archived before any deletions are > done. > > · Different archival ages can be set for different customers or > classes of tickets. > > · Different ages for associations can be set. > > · It is easy to add any customized tables to the tree. > > · It is easy to change or add archival targets: Archival forms, > different servers, SQL databases, the file system. > > · We get you going in a few hours with no server changes, no > development project, no headaches. > > > > *More Information* > > > > Meta-Archive Home <http://softwaretoolhouse.com/product/SthArch/> > > Meta-Archive Overview Leaflet > <http://softwaretoolhouse.com/product/SthArch/Meta-Archive-Overview-Leaflet.pdf> > > Management Overview > <http://softwaretoolhouse.com/product/SthArch/Meta-Archive-MgmtOview.wmv> > – Windows Movie (10 min.) > > Meta-Archive Fact Sheet > <http://softwaretoolhouse.com/product/SthArch/Meta-Archive-Fact-Sheet.pdf> > > ITSM Archiving White Paper > <http://softwaretoolhouse.com/product/SthArch/Meta-Archive-White-Paper.pdf> > > ü automating the data archiving process using purpose-built archive > systems make production systems run better > > ü searches are quicker and use less resources resulting in faster ITSM > application responses > > ü increased support personnel performance and satisfaction > > ü production performance is > > ü unaffected by information growth > > > > > > > > > > > > > > If you are interested in a presentation or a trial, please contact us at > sa...@softwaretoolhouse.com > > Cheers, > > Ben Chernys > Senior Software Architect > [image: Description: logoSthInc-sm] > > Canada / Deutschland > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: Ben.Chernys_AT_softwaretoolhouse.com > Web: www.softwaretoolhouse.com > > We are a BMC Technology Alliance Partner. > > > > > > Check out Software Tool House's free Diary Editor and our Freebies Section > for ITSM 7.6.04 and 8.0.0 Fields spreadsheets. > > *Meta-Update**,* our premium ARS Data tool, lets you automate your > imports, migrations, *in no time at all*, without programming, without > staging forms, without merge workflow. > > *Meta-Archive* does ITSM Archiving your way, with your tables and rules. > > > http://www.softwaretoolhouse.com/ > > > > > > > > > > > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > > -- > > *John Sundberg* > > *Kinetic Data, Inc.* > > *"Your business. Your process."* > > > > 651-556-0930 I john.sundb...@kineticdata.com > > www.kineticdata.com I community.kineticdata.com > > > > > > > [image: Image removed by sender.] <http://keg.kineticdata.com>_ARSlist: > "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ------------------------------ > This E-mail and any of its attachments may contain Time Warner Cable > proprietary information, which is privileged, confidential, or subject to > copyright belonging to Time Warner Cable. This E-mail is intended solely > for the use of the individual or entity to which it is addressed. If you > are not the intended recipient of this E-mail, you are hereby notified that > any dissemination, distribution, copying, or action taken in relation to > the contents of and attachments to this E-mail is strictly prohibited and > may be unlawful. If you have received this E-mail in error, please notify > the sender immediately and permanently delete the original and any copy of > this E-mail and any printout. > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
