C
CABI
Guest
Yes. A very nice Progress consultant called Gareth Payne did the dirty work of sorting out the type I to Type II mappings and sample code for parallel Dump and Loads. I used these as a template for each of our databases (we merged 4 of them as we went) and then fiddled with the Progress v9tov11 converter to account for the v10 conversation in the middle (significant head scratching was required). The dump and load on a 64 bit machine was mind blowingly fast: 7 databases in 7 hrs (including v9 restore and index builds). In version 9 a few years ago it to 18hrs for 1 database. The type II coupled with 32Gb ram (each database has 10-15% of its size in RAM) means our weekly load of data from our production system to our archive was taking 7hrs for 10,000 records and now it takes *1hr 15min*. So everything is going sooooo much faster. All that's really left is to do in the future is to re-build all the applications with 'new' and sensible code.
Continue reading...
Continue reading...