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

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

Hi Ludovic,
could you please update on this?

Thanks,
- Arun

On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <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...> 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...> wrote:
>>
>>> Hello Ludovic,
>>> Any update on this please?
>>>
>>> Thanks,
>>> - Arun
>>>
>>> On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <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...>
>>>> 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://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 <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...>
>>>>> 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...> 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$
>>>>>>
>>>>>>
>>>>>> <Screenshot 2021-11-23 at 3.20.39 PM.png>
>>>>>
>>>>>
>>>>>