30,997
edits
FAQ Increase Performance: Difference between revisions
Jump to navigation
Jump to search
m
→Search on beginning of field
mNo edit summary Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 93: | Line 93: | ||
Principle: When you have a high number of products or third parties, you must disable the "autocomplete" search or lists will take a long time to appear. First thing to do is to go into setup of module Product and Thirdparty and change the option "Wait you have pressed n keys before loading list of product/thirdparties/contact be loading combo list". And select n = 1 or 2. | Principle: When you have a high number of products or third parties, you must disable the "autocomplete" search or lists will take a long time to appear. First thing to do is to go into setup of module Product and Thirdparty and change the option "Wait you have pressed n keys before loading list of product/thirdparties/contact be loading combo list". And select n = 1 or 2. | ||
Also, you must know that searching a ref 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. You also have the constant COMPANY_DONOTSEARCH_ANYWHERE for searches of third parties. | Also, you must know that searching a ref 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. You also have the constant COMPANY_DONOTSEARCH_ANYWHERE for searches of third parties. | ||
== Disabling combo ajax == | |||
Efficiency: *** | |||
If you have a large number of third parties, contacts or products (> 5000), you can deactivate the product preloading feature to only load the list after clicking on 1, 2 or 3 characters. | |||
This is done from the configuration page of the Third Party or Product module. | |||
== Use a recent web browser == | == Use a recent web browser == | ||