hjgoldstein
Programmer
I have a Progress 8.3C multi-volume database running on a Win2K server.
There are 9 volumes of the .db file of 300Mb each and the tenth one is now over 1Gb.
I have a program which starts by building a temporary teble from two existing tables, total of about 4k records, and as it takes a little time for this to build, and the users of the system are always impatient, I have put a screen counter display while the temp table is building.
This used to take about a minute or so, but has now slowed so that it runs at no more than 5 records per second. Taking forever!
I have spoken to my network administrator who is reluctant to defrag the Win2K disk (don't know why.) I guess he will do it if it is a last resort!
Is it usual for the last volume of a multi-volume database to grow as this has? Is there a utility to "compact" "compress" or otherwise manipulate the Progress DB so that it will run faster?
Any help would be much appreciated.
There are 9 volumes of the .db file of 300Mb each and the tenth one is now over 1Gb.
I have a program which starts by building a temporary teble from two existing tables, total of about 4k records, and as it takes a little time for this to build, and the users of the system are always impatient, I have put a screen counter display while the temp table is building.
This used to take about a minute or so, but has now slowed so that it runs at no more than 5 records per second. Taking forever!
I have spoken to my network administrator who is reluctant to defrag the Win2K disk (don't know why.) I guess he will do it if it is a last resort!
Is it usual for the last volume of a multi-volume database to grow as this has? Is there a utility to "compact" "compress" or otherwise manipulate the Progress DB so that it will run faster?
Any help would be much appreciated.