1
0
-1

When I click on "Report-Software-Software", the page shows that the connection has been reset.

Mysql database "software" has about 100,000 pieces of data.  If I keep 10,000 data, I can open the software summary page.

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      FYI - That page will show software grouped by name so you shouldn't see an entry for every row in the software table.

      I suspect 100,000 rows into a table that is sorted by Javascript is simply too much for the browser to handle.

      I can see a bug here, so I'll see if I can get it fixed ASAP for our next release.

       

      You can always add ?limit=10 to the URL to reduce the number of returned rows.

      Following from that (?limit), you can use &offset=100 to point at the start of the set you're interested in.

      1. Mike Jiang

        According to what you said above,The URL is like this "http://localhost/open-audit/index.php/summaries/9/execute?limit=5&offset=1"; can open,But "http://localhost/open-audit/index.php/summaries/10/execute?limit=5&offset=1"; don't open yet,10 means system in this system. I met the same question, anything else can help me?

      2. Mike Jiang

        Update: 10 means Software and 9 means Services

      3. Mark Unwin

        Those URLs work for me. I have made a change for next release that limits rows according to the database_show_row_limit config item when requesting from Enterprise (which uses JSON to talk to Community). There should be no need to make any changes for Community.

      CommentAdd your comment...