Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id F1E07200CF8 for ; Thu, 14 Sep 2017 11:02:30 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id F0D361609CD; Thu, 14 Sep 2017 09:02:30 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 422A51609CC for ; Thu, 14 Sep 2017 11:02:30 +0200 (CEST) Received: (qmail 61967 invoked by uid 500); 14 Sep 2017 09:02:26 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 61953 invoked by uid 99); 14 Sep 2017 09:02:26 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Sep 2017 09:02:26 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id EE4B61A7BC7 for ; Thu, 14 Sep 2017 09:02:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id c7ComfYkmfdV for ; Thu, 14 Sep 2017 09:02:24 +0000 (UTC) Received: from mail-it0-f42.google.com (mail-it0-f42.google.com [209.85.214.42]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id B5D815FCB9 for ; Thu, 14 Sep 2017 09:02:23 +0000 (UTC) Received: by mail-it0-f42.google.com with SMTP id c195so4148156itb.1 for ; Thu, 14 Sep 2017 02:02:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=1b2HMF0YIgcaaeHJjvO8/Smmowvl5Jy6IfZ8/QXkTAY=; b=ptB3WS3tgSJD1uio0qAP6NAi/SdTKcdkC3Gfm5w/+8MyZbpvaL0u1WEgoH8m45FATh YRxIUE9QwVBzfs9Oy+N+kybojSS9gEHExKKbEP0ztn7UaZpEqQXzP5/ak0UnZBqiaqKw QDYLQE7F5EVKHJo2mruuFNpxPBFsBnQ8easHC1Q90GdBgER7XQGMT7NuKfqP4PYvHP8I fBYDEbP7JgE0QH0e0OJPuVdyi8e6XJCEGRFLUK2rjEto8rMYtV7LrsVGBZViCh3BAOZY dWKfZEv2XiShvCkxbE42Wv/N8gIV71cu5uj8pn02V7j0JCEKOx0B8bdJkfIzF+pyt5Lv KS/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=1b2HMF0YIgcaaeHJjvO8/Smmowvl5Jy6IfZ8/QXkTAY=; b=PY8Udy+5gbu+n+JOm6bnRL6wE6I0K0Tq2sc1z0Q1lESfH4/5TcnPGgOM24DQxGc8Cb yfAmFTOViM5rW2usjX7VthUVoIa7+/FVcCH2gZ0BwW47qoNGXLb8Tx+2viJBlXio0v6o LT97LkgRYFLZlM7psTlG6p5X++lOdAuWSZs4OVKpWRq2xRu6Gs6INc1MNml0+yZgLKV/ 1zVQsocWV90cQyDWl02pZpFDwz+gYsziTFoH7KgqRiYYd2O9LkM2qR7c0a1QNKZzkZLE Mrz1e6VED5nqdVSyOnn1OwVsqiJPxaBgPqpsdQvYxbdTUZVJJb1GE6ZEZlewl4KKaD+A SBcw== X-Gm-Message-State: AHPjjUi0fWuMX81LccKNsmGrHeVoROz/Jp+9Ou7mbEBQ8aAKh4ncugwh TipzIeeqEos4wVrJbL/cqlcdZBMaPLssZkjTa4k= X-Google-Smtp-Source: AOwi7QAzE6lZxvc4PqLm/AV3CpSEF5q6azHvO6kTbDpe8XqBwd4LWFJ1BjniRjyGT+7hu1u+lGLFjb9vGknzIyKOtFg= X-Received: by 10.36.107.146 with SMTP id v140mr2349829itc.95.1505379742533; Thu, 14 Sep 2017 02:02:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Sreenivas.T" Date: Thu, 14 Sep 2017 09:02:11 +0000 Message-ID: Subject: Re: Provide suggestion on indexing performance To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary="001a114aa68ace4ce505592288ee" archived-at: Thu, 14 Sep 2017 09:02:31 -0000 --001a114aa68ace4ce505592288ee Content-Type: text/plain; charset="UTF-8" I agree with Tom. Doc values and stored fields are present for different reasons. Doc values is another index that gets build for faster sorting/faceting. On Wed, Sep 13, 2017 at 11:30 PM Tom Evans wrote: > On Tue, Sep 12, 2017 at 4:06 AM, Aman Tandon > wrote: > > Hi, > > > > We want to know about the indexing performance in the below mentioned > > scenarios, consider the total number of 10 string fields and total number > > of documents are 10 million. > > > > 1) indexed=true, stored=true > > 2) indexed=true, docValues=true > > > > Which one should we prefer in terms of indexing performance, please share > > your experience. > > > > With regards, > > Aman Tandon > > Your question doesn't make much sense. You turn on stored when you > need to retrieve the original contents of the fields after searching, > and you use docvalues to speed up faceting, sorting and grouping. > Using docvalues to retrieve values during search is more expensive > than simply using stored values, so if your primary aim is retrieving > stored values, use stored=true. > > Secondly, the only way to answer performance questions for your schema > and data is to try it out. Generate 10 million docs, store them in a > doc (eg as CSV), and then use the post tool to try different schema > and query options. > > Cheers > > Tom > --001a114aa68ace4ce505592288ee--