\\
^**__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: [[aircastdbspeed:start|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.\\

\\
\\
[[https://www.dnrbroadcast.com/support-related|Support Request]]\\
\\
[[start:|{{:iconhome.png?100|Home}}]][[playoutoftware:start|{{:iconback2.png?100|Back}}]][[supaircast:start|{{:iconback1.png?100|Back}}]]
\\