First excuse me to link this post to you, but I think that is important, and for me VERY Important
I have an enviroment with 16500 computers, and 60 Storage Nodes growing, with location plugin. FOG 1.5.6
And I have this statistics:
hosts table: 16.500 records
Tabla snapins: 210
Tabla snapinAssoc: 45.403
Tabla snapinGroupAssoc: 15390
This is verified on FOG Version 1.5.6 and FOG Version 1.5.7
The following list of pages loads two slow, a few minutes:
host management -> Host general
host management -> Basic Task -> Deploy
host management -> Basic Task -> Snapins
Group management -> Snapins
Group management -> Basic Task -> Deploy
Group management -> Basic Task -> Snapins
Snapin management -> List All Snapins
... at least
First i think that was a database stress workload problem.
Second Speaking with @Fernando-Gietz we think that was a filter problem.
But as I was unable to create a filter that works.
Then reading the code a bit more i found that the problem is on the line 1297 on fog/lib/router/route.class.php
" ‘storagegroupname’ => $class->getStorageGroup()->get(‘name’)"
if you change the lines
‘storagegroupname’ => $class->getStorageGroup()->get(‘name’)
The pages goes much more faster.
I have commented that line and seems that all works correctly with our operations. But maybe is better than someone that knows what are doing take a look about that and can find a "Correct Solution".
Free to request more explanations.