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

[Zammit, L. <lu...@ak...>]

Hello Arun,

Could you check in chrome developper tool how long the request takes?

If you do Right click, Inspect and then Network.

Take a screenshot of that, it should look like this one:



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 Dec 7, 2021, at 11:01 PM, Arun Kangle <ak...@gm...> wrote:
> 
> Hi Ludovic,
> could you please update on this?
> 
> Thanks,
> - Arun
> 
> On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <ak...@gm... <mailto:ak...@gm...>> wrote:
> Hi Ludovic,
> Any update on this?
> 
> Thanks in advance,
> - Arun
> 
> On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <ak...@gm... <mailto:ak...@gm...>> wrote:
> Now I started getting the message "Request Failed with Status code 504" but i still can search users from "pfcmd" cli without any issue.
> 
> Thanks,
> - Arun
> 
> On Tue, Nov 30, 2021 at 7:42 AM Arun Kangle <ak...@gm... <mailto:ak...@gm...>> wrote:
> Hello Ludovic,
> Any update on this please?
> 
> Thanks,
> - Arun
> 
> On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <ak...@gm... <mailto:ak...@gm...>> wrote:
> >>>select count(1) from node;
> 
> MariaDB [(none)]> use pf
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Database changed
> MariaDB [pf]> select count(1) from node;
> +----------+
> | count(1) |
> +----------+
> |       69 |
> +----------+
> 1 row in set (0.000 sec)
> 
> MariaDB [pf]>
> 
> I am running it as a VM with 4 vCPU 16Gig RAM and 110GB Disk
> 
> Thanks,
> - Arun
> 
> On Tue, Nov 23, 2021 at 6:55 PM Zammit, Ludovic <lu...@ak... <mailto:lu...@ak...>> wrote:
> 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://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9pQVTNfdg$>  <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9qpinO9Ug$>  <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rCO-SIfQ$>  <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rM1iIeOw$>
> 
>> On Nov 23, 2021, at 4:55 AM, Arun Kangle <ak...@gm... <mailto:ak...@gm...>> 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 <lu...@ak... <mailto: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://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 <pac...@li... <mailto: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... <mailto:Pac...@li...>
>>> 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>
>