[ https://issues.apache.org/jira/browse/SOLR-9651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15583004#comment-15583004 ]
Mike commented on SOLR-9651: ---------------------------- I haven't read the super long SOLR-5944 issue, but the one thing I'll say about external file fields that's wonderful is that they can be updated in a flash. For a database with millions of documents, I can update them all just by updating a single file. That's very powerful and it'd be a shame if EFF were deprecated and I had to send a gazillion update queries to Solr to do the same. > Consider tracking modification time of external file fields for faster > reloading > -------------------------------------------------------------------------------- > > Key: SOLR-9651 > URL: https://issues.apache.org/jira/browse/SOLR-9651 > Project: Solr > Issue Type: Improvement > Security Level: Public(Default Security Level. Issues are Public) > Affects Versions: 4.10.4 > Environment: Linux > Reporter: Mike > > I have an index of about 4M legal documents that has pagerank boosting > configured as an external file field. The external file is about 100MB in > size and has one row per document in the index. Each row indicates the > pagerank score of a document. When we open new searchers, this file has to > get reloaded, and it creates a noticeable delay for our users -- takes > several seconds to reload. > An idea to fix this came up in [a recent discussion in the Solr mailing > list|https://www.mail-archive.com/solr-user@lucene.apache.org/msg125521.html]: > Could the file only be reloaded if it has changed on disk? In other words, > when new searchers are opened, could they check the modtime of the file, and > avoid reloading it if the file hasn't changed? > In our configuration, this would be a big improvement. We only change the > pagerank file once/week because computing it is intensive and new documents > don't tend to have a big impact. At the same time, because we're regularly > adding new documents, we do hundreds of commits per day, all of which have a > delay as the (largish) external file field is reloaded. > Is this a reasonable improvement to request? -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org