Re: Using Temp tables

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? If you are using 7.x version of online and did not turn on the temp flag when you created the temp dbspaces you can have major performance and logging problems. The way to fix is drop the tempdbspaces and recreate them with the temp flag on. Also if you are using 7.x make sure you allocate temp dbspaces. By default they go to root if you do not create temp spaces and put them in the onconfig file. This could cause performance problems too. > -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com