|
Without getting into long technical explanations, in a nut shell the Songs database has all the information in one table thus only has to search one list to find the requested information.
For the singers database there are two tables. One has the singers names and the pointer for the song (don't remember if it is the bookid or dickid-track and don't have a copy with me) and the other uses that pointer to list the song information stored there. So the singers database has to perform two searches to retrieve the information. The more singers and or the more song files added the slower it will get.
In order to speed it up MTU may need to revamp the way the tables are set-up to maybe include all the information into one table. Don't know if that would help the 100+ but would help if you have a lot of singers in the database.
__________________
Dale Douglass 2nd Generation Karaoke I am not a member of the MTU Staff.
|