Revision as of 14:56, 11 December 2014

Tweaks

The following sections are devoted to strictly performance. If there are always pros and cons when tweaking to read carefully. All Pros/Cons should be added.
'Pros description of the good
Cons description of the bad
'PvC Rating scale of 1 to 10, 1 being the ALL Con and 10 being ALL Pro

Use a Persistent DB Connection. This uses the already established connection to get the data, rather than reopening the socket or TCP link

Go to line

define('DATABASE_HOST',         'localhost');

Change to:

define('DATABASE_HOST',         'p:127.0.0.1');

Option	Pros	Cons	TOM Approved!
Persistent DB Connection	Speed in Web GUI response time	Connection is always open	9	✔

@@ Line 7: / Line 7: @@
 == Speed up DB queries ==
-*Use a Persistent DB Connection. This uses the already established connection to get the data, rather than reopening the socket or TCP link
+*Use a '''Persistent DB Connection'''. This uses the already established connection to get the data, rather than reopening the socket or TCP link
 #Open this file /var/www/fog/lib/fog/Config.class.php
 #Go to line <pre>define('DATABASE_HOST',         'localhost');</pre>
 #Change to: <pre>define('DATABASE_HOST',         'p:127.0.0.1');</pre>
+=Results=
 {| class="wikitable sortable" border="1" cellspacing="0" cellpadding="3"
 |-
-! Pros !! Cons !!
+! Option !! Pros !! Cons !! TOM Approved! !!
-|- Speed in Web GUI response time || Connection is always open || 9
+|-
+| Persistent DB Connection ||Speed in Web GUI response time || Connection is always open || 9 || &#10004;
 |}
-----