I've noticed when filtering the cast and crew on the profile screen, over time, it can take a while to filter the list.  A database repair gives the appearance of some improved performance for a short period of time.  All third-party plug-ins are disabled.  My main desktop isn't a new computer and is older, but are these repair times atypical?

The CreditsAssign took nearly 22 minutes and the ActorAssgn took another 13 minutes.


Repair of table Thumbnails started at 4/15/2017 10:05:49 AM
Repair of table Thumbnails completed at 4/15/2017 10:05:52 AM
Optimize of table Thumbnails started at 4/15/2017 10:05:52 AM
Optimize of table Thumbnails completed at 4/15/2017 10:05:52 AM
Repair of table Collection started at 4/15/2017 10:05:52 AM
Repair of table Collection completed at 4/15/2017 10:06:00 AM
Optimize of table Collection started at 4/15/2017 10:06:00 AM
Optimize of table Collection completed at 4/15/2017 10:06:04 AM
Repair of table Aliases started at 4/15/2017 10:06:04 AM
Repair of table Aliases completed at 4/15/2017 10:06:04 AM
Repair of table BoxSets started at 4/15/2017 10:06:04 AM
Repair of table BoxSets completed at 4/15/2017 10:06:04 AM
Repair of table CreditsAssign started at 4/15/2017 10:06:04 AM
Repair of table CreditsAssign completed at 4/15/2017 10:27:52 AM
Repair of table ActorAssgn started at 4/15/2017 10:27:52 AM
Repair of table ActorAssgn completed at 4/15/2017 10:41:03 AM
Repair of table Actors started at 4/15/2017 10:41:03 AM
Repair of table Actors completed at 4/15/2017 10:43:21 AM
Optimize of table Actors started at 4/15/2017 10:43:21 AM
Optimize of table Actors completed at 4/15/2017 10:44:12 AM
Repair of table DirectProduce started at 4/15/2017 10:44:12 AM
Repair of table DirectProduce completed at 4/15/2017 10:44:44 AM
Optimize of table DirectProduce started at 4/15/2017 10:44:44 AM
Optimize of table DirectProduce completed at 4/15/2017 10:44:57 AM
Repair of table Discs started at 4/15/2017 10:44:57 AM
Repair of table Discs completed at 4/15/2017 10:44:58 AM
Repair of table Events started at 4/15/2017 10:44:59 AM
Repair of table Events completed at 4/15/2017 10:44:59 AM
Repair of table Retailers started at 4/15/2017 10:44:59 AM
Repair of table Retailers completed at 4/15/2017 10:44:59 AM
Repair of table Studios started at 4/15/2017 10:44:59 AM
Repair of table Studios completed at 4/15/2017 10:44:59 AM
Repair of table TagAssign started at 4/15/2017 10:44:59 AM
Repair of table TagAssign completed at 4/15/2017 10:44:59 AM
Repair of table Tags started at 4/15/2017 10:44:59 AM
Repair of table Tags completed at 4/15/2017 10:44:59 AM
Repair of table TimeStamps started at 4/15/2017 10:44:59 AM
Repair of table TimeStamps completed at 4/15/2017 10:44:59 AM
Repair of table Users started at 4/15/2017 10:44:59 AM
Repair of table Users completed at 4/15/2017 10:44:59 AM
Optimize of table Users started at 4/15/2017 10:44:59 AM
Optimize of table Users completed at 4/15/2017 10:44:59 AM
Repair of table PluginCustomDataDef started at 4/15/2017 10:44:59 AM
Repair of table PluginCustomDataDef completed at 4/15/2017 10:44:59 AM
Repair of table PluginCustomData started at 4/15/2017 10:44:59 AM
Repair of table PluginCustomData completed at 4/15/2017 10:44:59 AM

I don't repair frequently as I'm not using it daily, but I think the last repair was about a month ago.  Either way, I wouldn't expect to have to repair that frequently.  The CPU usage during the repair was normally around 2-5% with a peak up to 20%, but that wasn't the only program that was open.

The time it takes to filter the cast/crew list before you can type another character is horrendous too.  The easiest way for me to enter cast/crew is to type out the names in notepad and then paste the names into the lookup field.