Re: Can You Help Me Speed Up!

Hi, Are your logical logs split off onto a separate device? If so move them to the fastest device available. I would expect this to help writes more than reads but if you have serious contention it may make a difference for you also. -Bill } } 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 } } } Thanks } } David M MacAllister } Securicor Omega International } Ayr } Scotland } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net