Which ones are set?

I guess I should also ask, what boxes are checked on the main properties tab?

Hi Mike, thank you for the response.

The boxes set are:

• Use LZ1
• Use DAOS
• Support Response Thread History
• Compress database design
• Allow soft deletions

One thing i forgot: the database in question has the archive option activated as well.

High activity on the DB would also be a factor -- given its size & the fact that it's archiving, I could also guess it could be a pile of deletion stubs caused by the archiver.

And ... the view discard rate and refresh method isn't changed, I assume. If you've been into a view design and played with some of the settings, lemme know. The view should be "auto, after first use" and discard should be the standard 45 days.

On the assumption that the fixup has truly fixed the basic structure of the database, I always try one additional thing: destroying & rebuilding the view. Shift-F9 will force the view to rebuild. It'll take time. I'm interested to know if the time it takes, is the same as the time it takes to open the view. So keep track if you would, please.

The parameters of the view are set to default.

The only thing left is the schedule of the re-indexing of the database which was set to hourly.

The default is immediately.

I'm going to monitor the situation and I let you now if there has been an improvement.

Thank you!