30,997
edits
| Line 53: | Line 53: | ||
Effciency: *** | Effciency: *** | ||
Principle: | Principle: If you activated, into Product module, the "autocomplete" search and list take a long time before to appear after typing a new character, this probably means you have an important number of product. Search is done everywhere in the text, so database index on field can't be used. By adding the constant PRODUCT_DONOTSEARCH_ANYWHERE to 1 into '''Home-Setup-Other''', you limit the search to the beginning of strings making possible for database to use index and you should get an immediate response. | ||
= Other solutions = | = Other solutions = | ||