Re: Using Temp tables

Posted in 1996

Cheryl Kendricks — 25 Apr 1996 22:53:34 -0400 — source: Informix-list mailing list archive (1991-1998)

It would help to know what version of the engine you are using. In 5.x temp tables are stored differently then in 6/7. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 25 Apr 1996, simon wrote: > Is it true that using TEMP TABLES in 4gl modules, would affect > performance in an application? > > Currently, i'm creating 2 temp tables (maximum size not more than 100 > rows) of which i will store and retrieve records from a production table. > > These tables will be dropped after the online entry is > completed, and will be recreated again when the user continues with > another data entry. > > How much of a systems performance will be afftected by the use of > temp tables? > > > > > > >