Can you tell us how many active links are in that table? On Tue, Aug 26, 2008 at 10:28 AM, BROTONS Oscar <[EMAIL PROTECTED]> wrote:
> ** ** > > Thank you Guillaume, > > I will ask for that to our db admin. > > > > -----Original Message----- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Guillaume Rheault > *Sent:* 26 August 2008 16:26 > *To:* [email protected] > *Subject:* Re: system table actlink_set and performance > > > > well you could always reorganize that table and rebuild the indexes. > That should make any query much faster. > > -Guillaume > > > -----Original Message----- > From: Action Request System discussion list(ARSList) on behalf of BROTONS > Oscar > Sent: Tue 08/26/08 9:26 AM > To: [email protected] > 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. > > > ********************************************************************************************** > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ------------------------------ > 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___ __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"
