Re: Can You Help Me Speed Up!

In article <651daq$j86@cssun.mathcs.emory.edu>, davidmc@sei.co.uk says... > >Hello and Help > >I'm having some problems with the response time for retrieving data when I >use unbuffered logging; a typical query will take around 6 seconds. >However when I change the logging status to No Logging, a query will take >about 1.5 to 2 seconds. > >Furthermore, when I retrieve a record, either through Unbuffered or No >Logging and then make a change to the record, the time taken to commit that >change is in the order of 5 or more seconds. > >Any hints for tuning will be most appreciated > Normaly the logging features only affects performance when data is changed. If you use temporary tables try to create them in a temporary dbspace and "with no log" parameter. Did you runned "update statistics" over the tables? Are you using triggers? some times the performance problems are related to some undercovered procedures when you update a row regards