Re: [PacketFence-users] Node search is very slow from GUI on version 11.0.0

[Arun K. <ak...@gm...>]

Hi Ludovic,
PFA screenshot. It took around 32 Seconds to search that user.

For total count, I am getting below error:

root@aolicnac:~# /usr/local/pf/bin/pfcmd node count all
Use of uninitialized value in join or string at
/usr/local/pf/lib_perl/lib/perl5/SQL/Abstract/Classic.pm line 1386.
nb

On Mon, Nov 22, 2021 at 11:53 PM Zammit, Ludovic <lu...@ak...> wrote:

> Hello Arun,
>
> How many device you have in the database ?
>
> Can you take a screenshot of your node search ?
>
> Thanks,
>
> *Ludovic Zammit*
> *Product Support Engineer Principal*
> *Cell:* +1.613.670.8432
> Akamai Technologies - Inverse
> 145 Broadway
> Cambridge, MA 02142
> Connect with Us: <https://community.akamai.com> <http://blogs.akamai.com>
> <https://twitter.com/akamai> <http://www.facebook.com/AkamaiTechnologies>
> <http://www.linkedin.com/company/akamai-technologies>
> <http://www.youtube.com/user/akamaitechnologies?feature=results_main>
>
> On Nov 19, 2021, at 1:23 AM, Arun Kangle via PacketFence-users <
> pac...@li...> wrote:
>
> Hello All,
> I recently upgraded to 11.0.0 (now to 11.1.0) from 10.3.0. Upgrade went
> fine and everything else works fine but Node search has become very slow.
> The first page (row length set to 10) itself takes very long and then
> equal long time to make any other search.
>
> Search is faster from CLI using the pfcmd command.
>
> Has anyone else faced this problem? If yes, any pointers on how to make it
> fast?
>
> root@aolicnac:/usr/local/pf/bin# cat /etc/debian_version
> 11.1
> root@aolicnac:/usr/local/pf/bin# ./pfcmd version
> PacketFence 11.1.0
>
> Thanks in advance,
> - Arun
> _______________________________________________
> PacketFence-users mailing list
> Pac...@li...
>
> https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$
>
>
>