Re: Can You Help Me Speed Up!

Posted in 1997

Ernesto Hern�ndez-Novich — Thu, 20 Nov 1997 10:56:21 -0400 — source: Informix-list mailing list archive (1991-1998)

David MacAllister wrote: > > 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 If you're only doing SELECT the logging mode is irrelevant, unless you're inside a transaction (BEGIN-COMMIT pair) using REPEATABLE READ isolation level. Is that your case? -- Ernesto Hern'ndez-Novich - emhn@telcel.net.ve Just another Unix/Perl/Java hacker. One thing is to be the best, and another is to be the most popular. Unix: Live free or die!