SQL logs does not always tell you the truth. Instead the API logs are better, they can tell you how long an operation takes. RRRLogs is a very good tools for examine perfromance, and it do show you the API transaction time. (but also a lot of other nice stuff)
Example: You create a record, the there is a lot of workflow trigger. Ie: notify a group of users. The SQL logs can show you that no SQL command takes longer than 0.010 seconds, but the API log shows that the create record took 5 seconds. And it spend much of the time creating records in AR System Email Messages form to notify all the users in the group. -- Jarl On Jan 10, 2008 6:43 PM, Kathy Morris <[EMAIL PROTECTED]> wrote: > ** > > Hi, > > I was curious what other people are doing to measure performance. We are > having some performance issues. I know we can run Remedy logging (SQL, > etc.). Is there a tool that we can use to capture these performance issues. > Also do most people use a separate Reporting Server to run reports? > > > > > ________________________________ > Start the year off right. Easy ways to stay in shape in the new year. > __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"
