Revision as of 15:04, 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');

Restart mysql:
```
service mysql restart
```
Open this file /opt/fog/.fogsettings (so updates to overwrite the settings above)
Go to line:
```
snmysqlhost="";
```
Change to:
```
snmysqlhost="p:127.0.0.1";
```

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

@@ Line 8: / Line 8: @@
 *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>
 #Change to: <pre>define('DATABASE_HOST',         'p:127.0.0.1');</pre>
 #Restart mysql: <pre>service mysql restart</pre>
-#Open this file /opt/fog/.fogsettings
+#Open this file '''/opt/fog/.fogsettings''' (so updates to overwrite the settings above)
 #Go to line: <pre>snmysqlhost="";</pre>
 #Change to: <pre>snmysqlhost="p:127.0.0.1";</pre>