Add detailed progress and guaranteed working cancel to Optimize, LR C

I sometimes have catalog "optimize" that runs for hours until I attempt to cancel it, then when it hasn't canceled after minutes, I wind up killing LR.

I really think there should be something more for users than an indefinite duration "progress, or progress?" bar to look at.

Some ▶ the user could click to obtain more information, for example, what phase of optimization? How long has it been running? How much of this phase has been completed? If it's been running for an hour, is that expected? Has it ground to a halt? Can I stop it while it's half done, with some improvement?

Second, cancel ought to work, always, and it ought to take just a few seconds at most.

The only reason that Lightroom users continue to use LR is that SQLite is utterly, absolutely, completely rock solid, as in, literally the most rock solid library in all of existence. If SQLite didn't tolerate almost infinite amounts of abuse, then after one or two crashes or power interruptions or lock ups, and consequent loss or corruption of enormous amonts of metadata, LR customers would be using different software.

Adobe, please stop leaning on SQLite to take care of the cases where broken "cleanup," "optimize," etc. doesn't work and the customer just kills and restarts the application. Fix the optimize and repair routines so that they do actually work reliably and predictably.