Start a new topic

Library management: optimize active database

Nothing seems to happen when I click on that button.

I think there should at least be a window telling me "Optimizing database. Please wait".

This operation can be very quick with MySql databases hence no message shows up.

It's much slower on Compact and Sql Server databases.

Implemented in 14260

What exactly optimization do and when it should be applied?


For CE databases it will compact them and rebuild thier indexes. For Sql Server it will defragment pages and rebuil indexes. For MySql it will rebuild indexes. Use if the database seems unusually slow or so.
Login or Signup to post a comment