Difference between revisions of "Fog Tweaks"

From FOG Project
Jump to: navigation, search
(Speed up DB queries)
(Speed up DB queries)
Line 7: Line 7:
 
== Speed up DB queries ==
 
== 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
 
#Open this file /var/www/fog/lib/fog/Config.class.php
 
#Go to line <pre>define('DATABASE_HOST',        'localhost');</pre>
 
#Go to line <pre>define('DATABASE_HOST',        'localhost');</pre>
 
#Change to: <pre>define('DATABASE_HOST',        'p:127.0.0.1');</pre>
 
#Change to: <pre>define('DATABASE_HOST',        'p:127.0.0.1');</pre>
  
 +
 +
=Results=
 
{| class="wikitable sortable" border="1" cellspacing="0" cellpadding="3"
 
{| 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;
 
|}
 
|}
 
----
 

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

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
  1. Open this file /var/www/fog/lib/fog/Config.class.php
  2. Go to line
    define('DATABASE_HOST',         'localhost');
  3. Change to:
    define('DATABASE_HOST',         'p:127.0.0.1');


Results

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