Re: Another intriguing one...

Posted in 1997

Jason Harris — Wed, 17 Sep 1997 00:01:22 GMT — source: Informix-list mailing list archive (1991-1998)

On Fri, 12 Sep 1997 22:46:16 +0100, David Williams <djw@smooth1.demon.co.uk> wrote: <snip> >> >>Under version 7.x, if one has correctly defined temporary dbspace(s) as >>non-logged, does a correlated subquery produce any log records? >> > Not sure, but since when a database has no logging defined DML > statements e.g. create table, drop table still get logged I would > assume so. > I believe that these are not logged. Certainly when using HDR data replication they are not logged. I believe that Informix took the logging out in temp db spaces to improve performance. >> >> >>Mark Collins >>mcollins@us.dhl.com >> >> > >-- >David Williams