Difference between revisions of "Fog Tweaks"
(→Speed up DB queries) |
(→Results) |
||
Line 16: | Line 16: | ||
{| class="wikitable sortable" border="1" cellspacing="0" cellpadding="3" | {| class="wikitable sortable" border="1" cellspacing="0" cellpadding="3" | ||
|- | |- | ||
− | ! Option !! Pros !! Cons !! TOM Approved | + | ! Option !! Pros !! Cons !! PvC !! TOM Approved !! |
|- | |- | ||
| Persistent DB Connection ||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 || ✔ | ||
|} | |} |
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
- Open this file /var/www/fog/lib/fog/Config.class.php
- Go to line
define('DATABASE_HOST', 'localhost');
- Change to:
define('DATABASE_HOST', 'p:127.0.0.1');
Results
Option | Pros | Cons | PvC | TOM Approved | |
---|---|---|---|---|---|
Persistent DB Connection | Speed in Web GUI response time | Connection is always open | 9 | ✔ |