B
bbrennan
Guest
Thanks Rich and Tom. The vendor seems to use major product releases to modify the scheme. The install kit that gets delivered applies incremental DFs to add and change tables and indexes. Those reference an area as Tom has surmised. Whatever I do needs to not break the ability of the customer to run the vendor upgrade when the time comes. I expect that after the upgrade, I will need to TABLEMOVE data and indexes into my new areas. I am just staring to test this. Since it is on a stand alone machine I can D&L or TABLEMOVE things to compare run times. for both the DBA setup activity as well as normal user execution. I expect to try and benchmark some standard heavy hitting processes to determine a rough idea regarding increased performance. Looking to justify the effort for a few customers I know in a similar circumstance. I have 2 sample databases. Once is about 10 gig and the other around 35 gig. Hopefully, with some useful feedback, I can work with the vendor on implementing a more modern database structure. From what I have seen out in the wild, there are great opportunities laying around for this sort of improvement. There are many vendors that still use areas by application function (AP,AR GL...) but have indexes and data mixed. Bob
Continue reading...
Continue reading...