Careful here. First searches are known to be slow, various caches are filled up the first time they are used etc. So even though you're measuring the second query, it's still perhaps filling caches.
And what are you measuring? The raw search time or the entire response time? These can be quite different. Try running with &debugQuery=on and one of the things you'll get back is the search time (not including assembling the response). You're right, though, 9 seconds is far too long. If you have a relatively small number of currency_ids, think about the "enum" method (see: http://wiki.apache.org/solr/SimpleFacetParameters#facet.method) Also, think about autowarming and firstsearch queries to prepare your solr instance for faster responses. If none of that helps, please post the relevant parts of your schema.xml and the results of running your query with &debugQuery=on, that'll give us a lot more info to go on. Best Erick On Mon, Nov 1, 2010 at 5:37 AM, stockiii <stock.jo...@gmail.com> wrote: > > my index is 13M big and i have not index all of my documents. the index in > production system should be about 30M Documents big. > > so with my test 13M Index i try a search over all documents, with > first query: q:[2008-10-27 12:23:00:00 TO 2009-04-29 23:59:00:00] > than i run the next query, for statistics. grouped by currency_id and get > the amounts, of these Currencys. > > thats my result: > -> EUR Sum: 437.259.518,28 € Founded: 3712331 > -> CHF Sum: 2.048.147,62 SFr. Founded: 10473 > -> GBP Sum: 1.221,41 £ Founded: 181 > > for getting the result solr needs 9 seconds. ... i dont think thats really > fast =( > what do you think ? > > > for faster search i want to try change precisionStep="6" to --> for > deleting > the milliseconds. whats the value for deleting also the seconds ? we only > need HH:MM and not HH:MM:SS:MSMS > and i change the datesearch from q to fq ... > > thx > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/is-my-search-fast-date-search-i-need-some-feedback-D-tp1820821p1820821.html > Sent from the Solr - User mailing list archive at Nabble.com. >
