Re: Low performance on temp tables with 7.31.FD3 on Digital Unix when created in tempdbs

js@jetsys.de (J?rg Spilker) wrote in message news:<4841fce4.0402182139.e8118d7@posting.google.com>... > Hello, > > > Yes ;) Bug 164089. > > hm, i didn't find this bug in the IDS 7.31 release notes? Can you > please post the bug description for me? > > > > It is related to the unnecessary checking of locks. > > > > Some other workarounds : > > > Reduce the amount of locks the session has by locking tables exclusively > > - this may be impractical. > > strange. As this was practical for the application, we did lock all > temp tables exclusive without solving the problem. Ok, hopefully this > bug is fixed in the 9.X IDS release to which we will change soon. > > Greetings, J'rg Try locking the real tables you are selecting from exclusively