Frequent softCommits leading to high faceting times?

[Rohit Kumar]

Hi,

We are running *SOLR 4.3* with 8 Gb of index on

Ubuntu 12.04 64 bits
Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz Single core.
16GB RAM


We just started using the autoSoftCommit feature and noticed the facet
queries slowed down from milliseconds taking earlier to a minute. We have *8
facet fields*.

We add close to 300 documents per second during peak interval.

<autoCommit>
    <maxTime>600000</maxTime>
    <openSearcher>false</openSearcher>
</autoCommit>

<autoSoftCommit>
    <maxTime>1000</maxTime>
</autoSoftCommit>


Here is some information i got with debugQuery. Please note that *facet
time is more than 50 seconds.*

<lst name="process">
    <double name="time">50779.0</double>
    <lst name="network">
        <double name="time">0.0</double>
    </lst>
    <lst name="query">
        <double name="time">41.0</double>
    </lst>
    *<lst name="facet">
        <double name="time">50590.0</double>
    </lst>*
    <lst name="mlt">
        <double name="time">0.0</double>
    </lst>
    <lst name="highlight">
        <double name="time">0.0</double>
    </lst>
    <lst name="stats">
        <double name="time">0.0</double>
    </lst>
    <lst name="connection">
        <double name="time">5.0</double>
    </lst>
    <lst name="debug">
        <double name="time">143.0</double>
    </lst>
</lst>

Please help.

Thanks,
Rohit Kumar