is my search fast ?! date search i need some feedback :D

[stockiii <st...@gmail.com>]

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.

Re: is my search fast ?! date search i need some feedback :D

[Erick Erickson <er...@gmail.com>]

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 <st...@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.
>