Re: How increase speed?

Rein Pre-create the temp file with an initial extent size. This will allocate all required space first and not have to keepo grabbing 8 page extents with all the associated overheads. Also create the table 'with no log' to avoid logical log write overheads. Keith On 23/11/06, Rein Puksand <rpuksand@epbe.ee> wrote: > Hi, > > Next query: > > "SELECT data.code1, data.code2, "D" AS flow, "151/501" AS class, data2.group > AS class1, data3.t_code AS class2, Sum(mb_data.deebet) AS summa, data.number > AS number, "MB" AS source > FROM data, data4, data2, data3 WHERE data4.period = data.period AND > data3.code = data.code AND data2.c_code =data.c_code GROUP BY data.code2, > data3.t_code , data2.group , data.code1, data.number > INTO TEMP break1;" > > Select works quikly (without insert), but insert to TEMP is slow. > (approx. 2000000 rows and takes 20 minuts .... Or It's normal? > > I'll need to insert difference data to other table and for it I am using > TEMP tables. > > How can increase speed ? Some experiense? > > Thanks advance, > > Rein > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >