Author Topic: Speed up database  (Read 7068 times)

0 Members and 1 Guest are viewing this topic.

Offline afrocuban

  • Moderator
  • *****
  • Posts: 535
    • View Profile
Speed up database
« 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

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Speed up database
« Reply #1 on: September 12, 2013, 05:35:28 pm »
What is the field you are searching?
Gentlemen, you can’t fight in here! This is the War Room!

Offline afrocuban

  • Moderator
  • *****
  • Posts: 535
    • View Profile
Re: Speed up database
« Reply #2 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.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Speed up database
« Reply #3 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?
Gentlemen, you can’t fight in here! This is the War Room!

Offline afrocuban

  • Moderator
  • *****
  • Posts: 535
    • View Profile
Re: Speed up database
« Reply #4 on: September 13, 2013, 10:09:45 am »
Thanks, nostra. I'm using both versions, same situation.