Personal Video Database

English => Support => Topic started by: afrocuban on September 11, 2013, 02:21:02 pm

Title: Speed up database
Post by: afrocuban on September 11, 2013, 02:21:02 pm

I have ~6,5k entries in my database. When I search it, it takes time to get results. So, very often, it's much faster to open Firefox, to enter search criteria at google, to open correspondent  IMDb page to get the results, then to get the very same result in already opened PVD.

So, is there any hint to make PVD database faster, or is it by design? If it's by design, what are the chances for nostra to make it faster?

Thanks in advance

Title: Re: Speed up database
Post by: nostra on September 12, 2013, 05:35:28 pm

What is the field you are searching?

Title: Re: Speed up database
Post by: afrocuban on September 12, 2013, 08:40:24 pm

Movie title, for example. What is really slow is searching "FronCover IS NULL"", but no alternatives for that query, so I have to wait. It takes at least a minute and a half.

Title: Re: Speed up database
Post by: nostra on September 12, 2013, 08:56:38 pm

Movie title should be quick as this field is indexed. There is not much I can do to spead it up. I will take a look if Ican optimize the search for covers. Are you using the latest beta?

Title: Re: Speed up database
Post by: afrocuban on September 13, 2013, 10:09:45 am

Thanks, nostra. I'm using both versions, same situation.