Re: Using TEMP Tables

Posted in 1995

Kerry Sainsbury — Fri, 12 May 1995 19:48:04 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <D85qAu.9L7@cix.compulink.co.uk>, dwc@cix.compulink.co.uk ("David Chan") wrote: > > Any extra overhead when dropping the table? > > Creating and dropping table does have an overhead so you should only do > it once per session i.e. don't drop and recreate within an application, > use delete instead. ... unless your temporary table has a lot of rows in it, in which case the overhead of DROPping/CREATEing is probably more acceptable than waiting for the DELETE to complete. Regards, Kerry S BTW: America's Cup, America's Cup... :-) ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.2 Mar 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html