Re: Performance Problem with Temp Table

Posted in 1994

"Paul Hatcher" — Tue, 1 Feb 1994 11:22:23 GMT — source: Informix-list mailing list archive (1991-1998)

> Why such a pronounced difference in the performace of that query with > the "no log" added to the creation of the temp table? Is this > platform/system specific or is it common across all platforms/systems? It's fairly consistent AFAIK. The speed increas is because inserts, updates and deletes to the temp table are not written into the transaction log. Paul Hatcher phatcher@cix.compulink.co.uk