Re: Logged temporary tables (was: Fill my rootdbspace, please)

Jonathan Leffler wrote: > > Mark D. Stock wrote: > > > [...sage advice about rootdbs...] Herbal. > > Moving your logs, databases and tables to other dbspaces is quite > > straight forward. It's usually temp tables that cause the problem, or in > > particular logging temp tables. These cannot be created in temp > > dbspaces. > > Can anyone think of a sound reason for wanting logged temp tables? Not I. > Why wasn't the default changed to 'WITH NO LOG' once the option > was introduced, with the analogous explicit 'WITH LOG [IN (dbspace1, > dbspace2, ...)]' being created for those circumstances that someone > will describe when a logged temp table is actually of some benefit? Give me a minute....., I know this one!...... No, I give in..., why? Seems like a simple enough change, but maybe it looks more difficult once you lift the hood? These things evolve over time (or for funny dried fruit :), but where we stand now, it seems ludicrous to consider logging temp tables. I would agree with you Jonathan! But then again I guess people on this list alone could produce an enormous list of 'silly' features in the engine alone. Like having to bounce the engine before parameter changes take effect. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+