Common WebUI pages takes minutes to load.

[EduardoTSeoane]

yes i can try it, are there any database change? from 1.5.6? maybe i can do a realistic test with the same stressed database.

A bit of info more:

The problem is located on snapin.class.php function getPrimaryGroup($groupID)

Maybe i cant dive a bit more on the code.

[Sebastian Roth]

@EduardoTSeoane With your very advanced setup I wouldn’t suggest you go to working-1.6 yet. If you update the DB schema there is no way back other than manually reverting the DB changes!!! I’d think it’s better we try to find the bottleneck in 1.5.x and port the fix to working-1.6 then as well.

This is verified on FOG Version 1.5.6 and FOG Version 1.5.7

Which version do you currently run?

[EduardoTSeoane]

@Sebastian-Roth 1.5.6 officially, and on my development/testing machine 1.5.7

[Sebastian Roth]

@EduardoTSeoane I will take a closer look at this on Friday evening (CET). Won’t find the time before that.

[Tom Elliott]

@EduardoTSeoane The get primary group error is likely from the typo for the snapin checking that has ‘prmary’ rather than ‘primary’

Can you look for the file that contains ‘prmary’ and add the I to it. This may or may not help, but at least the typo will be corrected either way.

[EduardoTSeoane]

@Tom-Elliott @Sebastian-Roth ok i try it tomorrow and tell you if it helps.

[EduardoTSeoane]

@Tom-Elliott @Sebastian-Roth
Typo corrected and don’t solve the problem, i dive a bit more on the code, and now i’m on
/var/www/html/fog/lib/fog/snapin.class.php

Commenting the code into the function getPrimaryGroup($groupID) // line 367

The WebUI has reasonable performance.

Then i think that the problem is that the nested loop in fastmerge function on line 2397 of fogbase.class.php, “is not so fast hehe”, maybe it helps.

A lot of thanks for your efforts in advance.

Maybe this night i can configure de working-1.6 personal test server with my production database.

[Quazz]

@EduardoTSeoane

Here is a possible alternative for the fastmerge function.

    public static function fastmerge($array1)
    {
        $others = func_get_args();
        array_shift($others);
        $array1 = array_merge($array1,...$others);

        return $array1;
    }

Though I expect performance difference to be minimal.

More likely that the problem lies in the sheer number of it.

Possibly 1.6 is a better environment for that.

[EduardoTSeoane]

@Sebastian-Roth @Tom-Elliott said in Common WebUI pages takes minutes to load.:

Would you mind trying on working-1.6? (Preferabbly the same database but on a test instance?) to see if performance is improved at all?

Ok, I’m ready to start the test, plz explain me how do you want the, bugs/problems report?

[Sebastian Roth]

@EduardoTSeoane said in Common WebUI pages takes minutes to load.:

Ok, I’m ready to start the test, plz explain me how do you want the, bugs/problems report?

Just report here in the forums as you did before. Or if you are keen you could also post an issue on github. Whichever suites you best.