P
Patrick Tingen
Guest
Is there a specific reason that you use small fixed extents? I am no DB expert, but my idea was that nowadays it is perfectly feasable to have a limited nr of large extents or - depending on the size of your db - perhaps even one variable extent with no fixed ones at all. In the old days we were limited by small memory allocations (-B) but today with 64 bit progress there is practically no limit on the size of the buffer pool, so you can virtually run your progress db as an in-memory database. My previous customer uses a -B of approx 200GB and hard drives are hardly doing anything so spreading your extents is not needed from a hardware point of view
Continue reading...
Continue reading...