29,133
edits
Changes
m
→Search on beginning of field
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 ==