It's been a while since I checked but I think with most DBMS, a
clustered index is stored in memory / pages once it's used. So if this
is large then you can end up with a buffer thats gigs right?
Agreed that indexes are great on large tables but I don't think it's an
excuse not to keep the tables trim. Also think about those people who
don't query with indexes.
Interesting topic though
------ Original Message ------
From: "Brittain, Mark" <mbritt...@navisite.com>
To: arslist@ARSLIST.ORG
Sent: 25/02/2015 19:17:53
Subject: Re: ADV: Meta-Archive Product Announcement: ITSM Archiving
**
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, mustnot be archived.
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
Meta-Archive Overview Leaflet
Management Overview – Windows Movie (10 min.)
Meta-Archive Fact Sheet
ITSM Archiving White Paper
ü 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
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
_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"