[jira] [Commented] (COUCHDB-2216) Changes table: Performance issue with larger databases

["Ben Keen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/COUCHDB-2216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14346187#comment-14346187 ] 

Ben Keen commented on COUCHDB-2216:
-----------------------------------

This problem is largely resolved by this PR: https://github.com/apache/couchdb-fauxton/pull/303

The biggest cause of the speed issue/freeze is the attempt to render all changes into the webpage. The new code caps it out at 1000 rows and shows a message at the top of the page saying that the results were truncated. Viewing the page under filters will continue to apply the filter to the entire list of changes & display as much as possible (up to 1000). This solution was suggested by Sean Barclay. 

> Changes table: Performance issue with larger databases
> ------------------------------------------------------
>
>                 Key: COUCHDB-2216
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-2216
>             Project: CouchDB
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: Fauxton
>            Reporter: Robert Kowalski
>            Assignee: Ben Keen
>
> Replicate a larger DB, e.g. https://skimdb.npmjs.com/ (around 250 MB JSON with ~65000 docs)
> Go to Database -> Changes
> Screen/Browsertab freezes (Chrome & Firefox)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)