Hello Arun, You can connect to the database and run that command:
select count(1) from node; What are the specs on your servers? CPU, RAM and disk. 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 23, 2021, at 4:55 AM, Arun Kangle <akan...@gmail.com> wrote: > > 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 <luza...@akamai.com > <mailto:luza...@akamai.com>> 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://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfK2klThA$> > > <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf1yplVhg$> > > <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfyTDbOew$> > > <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf4YbWArw$> > >> On Nov 19, 2021, at 1:23 AM, Arun Kangle via PacketFence-users >> <packetfence-users@lists.sourceforge.net >> <mailto:packetfence-users@lists.sourceforge.net>> 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 >> PacketFence-users@lists.sourceforge.net >> <mailto:PacketFence-users@lists.sourceforge.net> >> https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$ >> >> <https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$> >> > > <Screenshot 2021-11-23 at 3.20.39 PM.png>
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users