Can't compact database

[peterpix]

I have tried to run the compact process a few times and each time PSU starts off okay with the bar going back and forth in the activity area at bottom left, but pretty soon that stops and the bar at the top says that the program is not responding. I have left it for many hours including overnight but no difference. I started with trying to compact database and thumbs but then tried database only though without success either way. I have about 40k images in the database. How long should it take to compact?

EDIT: Since I last compacted a number of weeks ago I have added a lot of large files, some in excess of 100MB. Could that cause a problem?

Peter

[Hert]

EDIT: Since I last compacted a number of weeks ago I have added a lot of large files, some in excess of 100MB. Could that cause a problem?

Can you check if there's sufficient diskspace? There should be at least 3x the file size of the thumbs database as free disk space.

Also try to compact the database separately.

[peterpix]

Hi Hert thanks

That doesn't seem to be the issue.

Thumbs db is 12.2 Gb. Free space on disk is 68 Gb.

I tried only compacting the catalogue db (1.2 Gb) but that freezes PSU too.

Have not had this problem in the past.

PSU otherwise appears to be working okay.

Anything else I should try?

Peter

[peterpix]

Further to the above, though I have 16 Gb RAM I had quite a few programs running, so I have shut down everything else, restarted my computer, and closed all programs that start automatically. That has done the trick - I was able to compact. Thanks again for your earlier help above.

[Hert]

Compacting is a single database statement. And PSU has to wait for it. You can assume that the database is compacted, when on restart you don't get the notification that you should compact.
PS. Could it be that you start PSU with extra command line parameters?
PS2. Make sure that you exclude the catalog folder from any virus scanner that you have installed. That includes the default virus scanner in Windows (if using Windows).