Question: When we preform a search or accidently press one letter it will hours to get it right how can we fix this?
Question: When we synchronize music it takes about 10 minutes as our system meets the requirements?
Answer: Link: please follow the steps at this link


This is an immanent problem when doing full text searches in SQL databases. The database engine has to scan all records, which may take a long time depending on the number of items in the database. (This is unlike search engines like Google etc. that maintain a huge cache index of all possible full text search terms, enabling it to return results much quicker.)

Two possible solutions:

1. Right-click search field and disable “Advanced search”. Now you only get results that *start* with the search term, which will allow the SQL engine to use a so-called “index”, which makes it much faster.

2. To avoid that people accidentally start searches with too short terms, there is a hidden setting in the GUI.ini file (to be found in the config folder, see config app → Advanced → Data Folders). Open the file in a text editor and add these two lines:

[DatabaseSearch]
MinChars=3

Now the search box will refuse to start the search unless you enter at least three characters.



Support Request

HomeBackBack