egarciad
27th March 2007, 22:35
Hello there,

Recently we buy Quest Space Manager with Live Reorg, in order to make tables reorganization easier. So I already had reorganized some small tables, but a few days ago I did it with table tfacr200, because some user has complained about decrease in performance in some sessions using that table. At the begining, it takes almost 3 minutes each transactions to do, but after I made the reorganization with the Quest tool, it took foerver in doing just one transaction.... almost 4 hours... hours!!!

I asked to Baan support and they told me that I must reorganize tables using Baan tools, because of some internal process that the driver do. So I reoganized the table again using Baan and the times came again to the 3 minutes rate per transaction.

So the question is, has anyone had a similar experience with Quest Live Reorg? Have you ever reorganized tables with others tools than Baan?
Live Reorg is a great tool, you don't have to shutdown database to manage spaces, tables and indexes, but with this issue I am now wondering if there is anything I can do to make use of this tool.

Any coments or sugestions will be highly valuable.

Thanks in advance.

Eric