FAQ Increase Performance: Difference between revisions

FAQ Increase Performance (view source)

200 bytes added , 5 years ago

m

no edit summary

30,997

edits

@@ Line 85: / Line 85: @@
 Efficiency: ***
-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. You also have the constant COMPANY_DONOTSEARCH_ANYWHERE for searches of third parties.
+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.
 == Disable ajax combo ==