Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Database Repair timeline
Author Message
DVD Profiler Unlimited RegistrantStar Contributorrdodolak
Registered: March 18, 2007
Reputation: High Rating
United States Posts: 1,129
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar ContributorWigram
Don't blink!
Registered: June 6, 2007
Reputation: High Rating
Canada Posts: 841
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
On my collection of about 3300 profiles, this is what happens for a Full Database repair called from DVDProfiler Tools menu:

Repair of table Thumbnails started at 2017-04-15 14:24:19
[...]
Repair of table CreditsAssign started at 2017-04-15 14:24:24
Repair of table CreditsAssign completed at 2017-04-15 14:29:27
Repair of table ActorAssgn started at 2017-04-15 14:29:27
Repair of table ActorAssgn completed at 2017-04-15 14:32:25
Repair of table Actors started at 2017-04-15 14:32:25
Repair of table Actors completed at 2017-04-15 14:33:23
Optimize of table Actors started at 2017-04-15 14:33:23
Optimize of table Actors completed at 2017-04-15 14:33:51
Repair of table DirectProduce started at 2017-04-15 14:33:51
Repair of table DirectProduce completed at 2017-04-15 14:34:03
[...]
Repair of table PluginCustomData completed at 2017-04-15 14:34:10

Those are fairly reproducible numbers: 5-6 minutes for CreditsAssign, 3-4 minutes for ActorAssign. How often do you repair? (I do a repair daily, as well as a daily backup).
DVD Profiler Unlimited RegistrantStar Contributorrdodolak
Registered: March 18, 2007
Reputation: High Rating
United States Posts: 1,129
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next