Re: Using TEMP Tables

Michael Strother (mstrothr@informix.com) wrote: : > : > What is the overhead when in 4gl you "create TEMP table...", load it : > with something, then "Drop" it? : Same as any other table pretty much : >Do temp tables take more overhead than a "permanent" table? : No not really but you may want to avoid having it created in the root dbspace : by specifying a tempdbspace. You also want to remember that a temp : table is on a per user basis, so you may have more temp tables than you think. : >Does it take longer to retrieve things from it? : No longer than a permanent table of the same size : > Any extra overhead when dropping the table? : No more than a permanent table : >We load an average of a couple hundred rows or less. : >The size of the row is 2 char columns, total row size is 50. : > : > We are on SCO Unix online 5.01. : > : > Steve Goldberg : > Landata RE-Source : > goldberg@landata.com : > Whilst all true up to a point, I find this potentially misleading in that, providing you use the WITH NO LOG option and/or put your temporary table in a temporary dbspace you will actually get *LOWER* overhead. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.