Re: Online 5.03 real slow performance

Thuc Nguyen <thucn@email.utcourts.gov> wrote in article <5j8qq8$m5h@cssun.mathcs.emory.edu>... > I have spent a few days looking at the REAL slow performance problems > and have tried LRU_MAX-DIRTY/LRU_MIN_DIRTY,LTXHWM/LTXEHWM, > and BUFFERS adjustment. Nothing worked. The users complained that it > took them 30min to 1 hour to bring up a record, that should be less than a > few seconds, especially in the waiting line. I have included the tbconfig > and kernal parameters info to see if anyone there can correct it. Is there > something else I am missing. I have also reviewed the index issue. > > Online 5.03 You say you "reviewed the index issue". Did you see what the query optimizer was doing by looking at the output from a "set explain"? Did you recently rebuild a table (indexes and all) but not run an "update statistics"? -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com