** 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" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ********************************************************************************************** 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"
