Hi all
I've just upgraded to an SSD drive fresh install of windows and updated to openlp version 3.1.6
When searching for songs it's very slow and if I press delete to clear the text search it is lagging.
Sometimes there is a message saying openlp is not responding.
Is my database too big or need indexing.
I upgraded to make things faster but now it's even slower.
Cheers Marcus
ok i have had time to try and sort this but no luck so far.
i have used AI to try and help and it suggested to use SQLlite to run
Vacuum
and to index the Title
however this has no effect on speeding things up.
I ran the upgrade on another machine and it did the same thing.
The CPU goes up to 50% when you start to delete the search so you can try another name.
as you get to the last letter Openlp says not responding and then comes back to life.
The CPU then drops and you can then do another search. this is a repeating pattern, and on different hardware.
Ai says that the software is working too hard searching the song Database as you delete each letter and this takes too much CPU power. The older version of of Openlp 3.0.2 did not have this issue so there is something happening with the upgrade to cause this.
I did try the latest version to see if that would help but its just the same 3.1.6.
Not sure how to proceed other than reverting back to the old version and never upgrading.
