Re: Selecting data with an order on string field causes slow commits from then on

2008-05-12 Thread Mike Klaas
This was answered yesterday on the list: http://www.nabble.com/Re%3A-exceeded-limit-of-maxWarmingSearchers-p17165631.html regards, -Mike On 12-May-08, at 6:12 PM, David Stevenson wrote: We have a table that has roughly 1M rows. If we run a query against the table and order by a string field

Selecting data with an order on string field causes slow commits from then on

2008-05-12 Thread David Stevenson
We have a table that has roughly 1M rows. If we run a query against the table and order by a string field that has a large number of unique values then subsequent commits of any other document takes much longer. If we don't run the query or if we order on a string field with very few unique value