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.
ALL these Settings must be changed by the FOG User.
DO AT YOUR OWN RISK
Pros description of the good
Cons description of the bad
PvC A rating scale of 1 to 10, 1 being the ALL Con and 10 being ALL Pro
Dev. Approved One or multiple developers of Fog has approved this setting to be used in most installations of FOG.

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

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/upgrades to overwrite the settings above)
Go to line:
```
snmysqlhost="";
```
Change to:
```
snmysqlhost="p:127.0.0.1";
```

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