FAQ Increase Performance - Revision history

Eldy: /* Recommanded solutions */

2023-02-27T13:20:48Z

Recommanded solutions

← Older revision		Revision as of 13:20, 27 February 2023
Line 15:		Line 15:
	= Recommanded solutions =		= Recommanded solutions =

	From v14, you will find into menu Home - Admin tools - Performances, a page with advice on your setup to get the best performance of your application. Start with that if your version is v14+.		From v14, you will find into menu '''Home - Admin tools - Performances''', a page with advice on your setup to get the best performance of your application. Start with that if your version is v14+.

	You can then complete with the following recommendations...		You can then complete with the following recommendations...

Eldy at 13:20, 27 February 2023

2023-02-27T13:20:34Z

← Older revision		Revision as of 13:20, 27 February 2023
Line 15:		Line 15:
	= Recommanded solutions =		= Recommanded solutions =

	From v14, you will find into menu Home - Admin tools - Performances, a page with ~~advices~~ on your setup to get the best performance of your application. Start with that if your version is v14+.		From v14, you will find into menu Home - Admin tools - Performances, a page with advice on your setup to get the best performance of your application. Start with that if your version is v14+.

	You can then complete with the following recommendations...		You can then complete with the following recommendations...
Line 28:		Line 28:
	Efficiency: *		Efficiency: *

	Principle: HTTP/2 protocol is know to be faster than HTTP/1.1. So if your OS and webserver is ~~comaptible~~, just enable it.		Principle: HTTP/2 protocol is know to be faster than HTTP/1.1. So if your OS and webserver is compatible, just enable it.

	== Disable xdebug ==		== Disable xdebug ==

Eldy: /* Search on beginning of field */

2023-02-27T13:17:37Z

Search on beginning of field

← Older revision		Revision as of 13:17, 27 February 2023
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 ==

Eldy at 08:59, 17 January 2023

2023-01-17T08:59:37Z

← Older revision		Revision as of 08:59, 17 January 2023
Line 53:		Line 53:

	Principle: You can setup apache to activate explicit cache of static resources by adding following directives:		Principle: You can setup apache to activate explicit cache of static resources by adding following directives:
	<~~source~~ lang="ini">		<syntaxHighlight lang="ini">
	# Cache for static resources (Enable expiration and set it to A2592000 = 1 month)		# Cache for static resources (Enable expiration and set it to A2592000 = 1 month)
	ExpiresActive On		ExpiresActive On
Line 64:		Line 64:
	ExpiresByType application/x-javascript A2592000		ExpiresByType application/x-javascript A2592000
	ExpiresByType application/javascript A2592000		ExpiresByType application/javascript A2592000
	</~~source~~>		</syntaxHighlight>
	Again, gain is cumulative with other previous caches.		Again, gain is cumulative with other previous caches.

Line 73:		Line 73:

	Principle: You can setup apache to activate compression of returned resources by adding following directives:		Principle: You can setup apache to activate compression of returned resources by adding following directives:
	<~~source~~ lang="ini">		<syntaxHighlight lang="ini">
	# Compress returned resources of type php pages, text file export, css and javascript		# Compress returned resources of type php pages, text file export, css and javascript
	AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript application/x-javascript		AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript application/x-javascript
	</~~source~~>		</syntaxHighlight>
	[[File:warning.png]] After adding this, you must reload web server setup but also clear local cache browser to force browser to ask full file again and get new header.		[[File:warning.png]] After adding this, you must reload web server setup but also clear local cache browser to force browser to ask full file again and get new header.

Line 83:		Line 83:

	Principle: If you use a mysql database, check into your Dolibarr config file htdocs/conf/conf.php that you have the line		Principle: If you use a mysql database, check into your Dolibarr config file htdocs/conf/conf.php that you have the line
	<~~source~~ lang="php">		<syntaxHighlight lang="php">
	$dolibarr_main_db_type='mysqli';		$dolibarr_main_db_type='mysqli';
	</~~source~~>		</syntaxHighlight>
	If value is '''mysql''', change it into '''mysqli''' that provide better performances (gain is 30ms for each page call).		If value is '''mysql''', change it into '''mysqli''' that provide better performances (gain is 30ms for each page call).

Eldy at 15:45, 22 July 2021

2021-07-22T15:45:10Z

← Older revision		Revision as of 15:45, 22 July 2021
Line 70:		Line 70:

	== Enable compression of resources by Apache ==		== Enable compression of resources by Apache ==
	Efficiency: ***		Efficiency: *** (on low bandwith network)

	Principle: You can setup apache to activate compression of returned resources by adding following directives:		Principle: You can setup apache to activate compression of returned resources by adding following directives:

Eldy at 15:43, 22 July 2021

2021-07-22T15:43:24Z

← Older revision		Revision as of 15:43, 22 July 2021
Line 38:		Line 38:

	== Applicative cache using MemCached ==		== Applicative cache using MemCached ==
	Efficiency: *** (if you use a Windows server, * on linux)		Efficiency: *** (if you use a Windows server) or * (on linux server)

	Principle: Installing a memcached server and the [[Module MemCached EN\|Module MemCached]].		Principle: Installing a memcached server and the [[Module MemCached EN\|Module MemCached]].

Eldy at 15:41, 22 July 2021

2021-07-22T15:41:53Z

← Older revision		Revision as of 15:41, 22 July 2021
Line 14:		Line 14:

	= Recommanded solutions =		= Recommanded solutions =

			From v14, you will find into menu Home - Admin tools - Performances, a page with advices on your setup to get the best performance of your application. Start with that if your version is v14+.

			You can then complete with the following recommendations...


	== Use the latest PHP version ==		== Use the latest PHP version ==
	Efficiency: ***		Efficiency: ***

Eldy at 15:38, 22 July 2021

2021-07-22T15:38:34Z

← Older revision		Revision as of 15:38, 22 July 2021
Line 100:		Line 100:
	= Other solutions =		= Other solutions =
	All solutions here are categorized into an "Other solutions" because they are '''not''' recommended. All of them may needs advanced technical knowledge, may not be stable, not supported or may break some features... but they exists, so use them only if you know what you do !		All solutions here are categorized into an "Other solutions" because they are '''not''' recommended. All of them may needs advanced technical knowledge, may not be stable, not supported or may break some features... but they exists, so use them only if you know what you do !

	~~== Applicative cache using Shared memory ==~~
	Efficiency: ****

	~~Pre-requisites: Using an Ap~~

	== Disable "on fly" PDF generation ==		== Disable "on fly" PDF generation ==

Eldy at 15:37, 22 July 2021

2021-07-22T15:37:51Z

← Older revision		Revision as of 15:37, 22 July 2021
Line 87:		Line 87:
	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.

	~~== Disable ajax combo ==~~

	== Use a recent web browser ==		== Use a recent web browser ==

Eldy at 15:37, 22 July 2021

2021-07-22T15:37:30Z

← Older revision		Revision as of 15:37, 22 July 2021
Line 83:		Line 83:

	== Search on beginning of field ==		== Search on beginning of field ==
	Efficiency: ***		Efficiency: * to *****

	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.