View Single Post
Old 1st February 2002, 15:48
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
Baan tables and performance

One thing we did notice after some of the upgrades was that a 'Baan Reorg' of the Item master table did improve certain areas but why a Baan reorg of this table improved performance and not an Oracle reorg is still a mystery.
On one system when we where deting a user (from Baan), the process would take more than 1 hour to do so (600 users in ttaad200, 400.000+ records on ttaad231).

When doing a global change, I dumped the table ttaad231 and noticed duplicate entries there - removed the duplicates, re-imported the table with deletion of current, puf, deletions in 5 to 10 seconds!
Reply With Quote