Re: 7.23 doesn't use tempdbs

Richard Woolfall wrote: > > Gabriela Bellani wrote: > > > > Are you creating your temp tables with the option WITH NO LOG > ? > > create temp table your_table > > ( .... > > ) with no log; > > > > OR > > > > select anything_you_want into temp your_table with no log; > > > > If not they are created in a dbspace with logging ..... > > I've come across this before (Informix 7.2x on HP-UX, but I expect > it's the same issue as you're seeing). > > What I think is happening is that Informix can't perform logging > on a dbspace created with -t, but your database has logging > switched on - so Informix creates the table elsewhere so that it > can log it. (Strange reasoning - I know!) > > If you don't want to have to use "with no log" on all your SQL, > then you can drop and recreate your tempdbs dbspace without the > -t option. You can still use this dbspace for temp tables. > Personally I've never used the -t option because of this > downside. Is there any advantage in using it? Of course! Temp dbspaces don't get archived. Also, logging is a performance overhead, not to mention filling up your logs. Why log temp tables when you don't have to? ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+