| 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.
