Re: Using Temp tables

Hi Simon, Yes , this is very true. We have used 'create temp table' mostly to increase the speed of 4gl queries and data entry programs. Ravi..... On 25 Apr 96 , simon <simony@pacific.net.sg> 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? } } } } } } } \