[Health-dev] [bug #61848] Created Invoices menu taking too long to get invoices from database

[Humberto Freitas]

URL:
  <https://savannah.gnu.org/bugs/?61848>

                 Summary: Created Invoices menu taking too long to get
invoices from database
                 Project: GNU Health
            Submitted by: noosanon
            Submitted on: Tue 18 Jan 2022 07:57:12 PM UTC
                Category: Functionality
                Severity: 3 - Normal
              Item Group: None
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
                 Release: None
         Discussion Lock: Any
                  Module: Health Services

    _______________________________________________________

Details:

Client: Tryton Client, GNU Health client
Server: GNU health 3.8
OS: Debian 11
Database: Postgresql 13

Hello guys, I hope everything is all right with you.

I'm having a really strange problem which happens when I click on the Created
Invoices menu inside Health Services menu.

It takes more than a minute to get the data from the database, and while it
waits for the data the client program hangs unresponsive unlike any other
menu.

When I tried to click on other menus in which returns more data than the
Created Invoices menu, for example the client invoices inside the Financial
Menu from the account module, the client program behaves as it should,
returning the data normally even though it has more invoices than the Created
Invoices menu have. I've also tried to click on other menu like the
prescriptions menu and it returns more data than the Created Invoices and it
behaves normally.

Another thing that happens is that, when I click on the Created Invoices menu
and run htop program to check the resources consumed, the CPU usage goes up to
100% for the duration of all query.

Even though I tried to decrease the Search limit to 50, it still take much
time to get the data from the database.

It's also important to note that, it's only this menu that has this problem.

I attached a photo with the htop running so you can see the query running on
the database and its consumption.

I hope you guys can help me with this.

Thank you so much for all your work.

Happy new year for all.

Cheers




    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?61848>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/