View Single Post
  #27  
Old December 15th, 2011, 04:53 AM
admin admin is offline
Administrator
 
Join Date: Oct 2000
Location: Raleigh, NC, USA
Posts: 10,515
Re: singer search slow

Quote:
Originally Posted by bugspappaw View Post
If I rename my existing singer database, will it automatically create a new singer database when I add a singer and song through hoster or do I have to have an existing database for it to write to?
You should upgrade to version 5.05. It was released 12/12/2011. In version 5.03 and 5.04, we added indices for often used fields. Doing a Singer's search is now 10 to 100 times faster.

Hoster was originally designed for 10,000 to 20,000 songs, and the Singers DB was not there. When we added indexing audio and video files into the Songs DB, that expanded their Songs DB. One user reports he "legally" has 30,000 Karaoke songs, 30,000 Audio, and 1,000 video files. He was taking 52 seconds to find a song in the Singers DB.

To meet the growing needs of our users, we continually upgrade Hoster. The only way to receive the benefits is to upgrade to the latest version.

There were a few users who had difficulties with 5.03 and 5.04, and we addressed each concern. We believe that 5.05 stablilizes the new functions added from 5.00 up.

Hoster 5.05 should do Singer searches in a few seconds. Yes, Singer... because Songs in the Singers DB are linked through the Songs DB to the song. The indexing we did in the Songs DB makes this "double accessing" significantly faster.

The only warning is you may not be able to return to 4.32 or even 5.02 once you upgrade to 5.03. That's where we added indices to the Songs and Singers Databases. Some other "parameter invalid" has also been reported, but never duplicated. So, if you want speed improvements, upgrade to 5.05. If you are afraid to upgrade, wait and see what others post about using 5.05.
__________________
Making Karaoke the best it can be!
http://www.mtu.com/
Reply With Quote