singer search slow

[mce05]

Originally Posted by ddouglass

First lets get the terms right. You have two database files. The main one is the Songs.mdb (Songs database) file which has all the songs listed that you have imported. The second is the Singers.mdb (Singers database) file which has the singers name and the songs they sing.
There is no limit on how many songs a singer can have listed. However realize that the more one singer has the slower it will be to open their list. Anything over about 200 is going to be extremely slow, thus the times you listed. The different rates would be depending on processor speed, other processes running, memory available, and a lot of other things within the individual computer.
I would recommend parrying down that 384 to about half. I am sure there are a lot of songs the individual has not sang for a very long time and most likely will not sing again. Same with any others you have that are very large.

What version did you upgrade from? If you were using one several versions back, then yes it may seem slower now with 4.32 because there are more features that have been added.

Thanks for the response and the clairfication about the two databases. I do understand that I must now pare down the songs to 200 or less. What I don't understand is why that seems to apply to only version 432.03. I also hope that every one understands that there have been many minor changes since last September.

06/08/2003 original install of Hoster 3.108 on Inspirion 9300 laptop

There were many upgrades in between..

9/30/2010 installed 431 upgrade.. no problems
10/07/2010 installed 431.1 upgrade .. no problems
12/09/2010 installed 432.01 upgrade .. no problems
2/14/2011 Installed 432.1 upgrade .. no problems
3/?/2011 Installed 432.03 upgrade ... problem

If you noticed the slowest computer (laptop) ran the fastest whereas the newest with the fastest prossessor (HP) runing windows 7 pro was the slowest.

Also under the help tab of hoster checking about, still show the version as 432 not 432.03.. I also find it a bit confusing .03 is smaller than .1 (personally I would have used .3 as the newest version)

In conclusion I hope that you now understand that in one month the amount of of songs a singer has did not significantly change. But the last update did slow considerably the time it takes to access them.

Cort