Joe, I agree with you regarding the size and efficiency of the table, however, if the statistics on the database are not being updated the indexes will be out of date and the system will still do a table scan. I would check to see how often the database statistics are updated, or if they have been updated recently.
That would be the first stop for me. Brian Goralczyk 2008/8/26 Joe DeSouza <[EMAIL PROTECTED]> > ** > ACTLINK_SET is an internal meta data table, that the AR System uses to > store information of all the Set Fields actions from all Active Links.. > > Considering that nearly 70% to 80% or even more Active Links from most > systems contain set field actions, this table is expected to be pretty > large.. > > This table is already appropriately indexed for use by Remedy to avoid any > table scans when the system is reading information from this table at the > time of building its cache, and there is not much you can do about further > improving performance as basically whenever there is a search to this table, > the search is against a significantly larger table than most of your other > data tables. > > This search however would happen only during system startup, when the > system is reading all the definitions to build up its cache, and at the time > there is a recache of definitions when there are changes in the active > links. It shouldn't significantly impact end users non-development users. So > even if there was a way to bring down your 4 seconds to something lower, you > aren't really going to achieve much.. > > Joe > > > ----- Original Message ---- > From: BROTONS Oscar <[EMAIL PROTECTED]> > To: [email protected] > Sent: Tuesday, August 26, 2008 9:26:56 AM > Subject: system table actlink_set and performance > > ** > > Hi all, > > I'm trying to improve the performance on our environment and in api-sql > logs analized with arwklga.exe I get that the worst query I've doing is SELECT > actlink_set, with an average of 4,24 seconds. I found this unacceptable > because is not my workflow but remedy who runs that. > > Have someone an idea about what could be happening? > > Thanks a lot. > > Oscar Brotons. > > IT Consultant. > > ------------------------------ > IMPORTANT: This message is intended exclusively for information purposes. > It cannot be considered as an official OHIM communication concerning > procedures laid down in the Community Trade Mark Regulations and Designs > Regulations. It is therefore not legally binding on the OHIM for the purpose > of those procedures. > The information contained in this message and attachments is intended > solely for the attention and use of the named addressee and may be > confidential. If you are not the intended recipient, you are reminded that > the information remains the property of the sender. You must not use, > disclose, distribute, copy, print or rely on this e-mail. If you have > received this message in error, please contact the sender immediately and > irrevocably delete or destroy this message and any copies. > ------------------------------ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
