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 90114200B62 for ; Fri, 12 Aug 2016 20:53:00 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 8EC1F160AB0; Fri, 12 Aug 2016 18:53:00 +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 ADEEF160A85 for ; Fri, 12 Aug 2016 20:52:59 +0200 (CEST) Received: (qmail 83855 invoked by uid 500); 12 Aug 2016 18:52:58 -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 83839 invoked by uid 99); 12 Aug 2016 18:52:57 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Aug 2016 18:52:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 5EB96C147D for ; Fri, 12 Aug 2016 18:52:57 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.519 X-Spam-Level: X-Spam-Status: No, score=-0.519 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.519] autolearn=disabled Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 5WMB_pyIq3i8 for ; Fri, 12 Aug 2016 18:52:55 +0000 (UTC) Received: from mail.whitepages.com (mail.whitepages.com [64.124.61.69]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 2CDF65F29B for ; Fri, 12 Aug 2016 18:52:54 +0000 (UTC) Received: from ex9.corp.w3data.com (10.120.0.81) by ex8.corp.w3data.com (10.120.0.80) with Microsoft SMTP Server (TLS) id 15.0.1156.6; Fri, 12 Aug 2016 11:50:11 -0700 Received: from ex9.corp.w3data.com ([fe80::9ca5:2861:30a7:94df]) by ex9.corp.w3data.com ([fe80::9ca5:2861:30a7:94df%22]) with mapi id 15.00.1156.000; Fri, 12 Aug 2016 11:53:00 -0700 From: Jeff Wartes To: "solr-user@lucene.apache.org" Subject: Re: Effects of insert order on query performance Thread-Topic: Effects of insert order on query performance Thread-Index: AQHR8/dch+y7T/cEi0CX6MsbudTrSaBFd5+AgAA13QA= Date: Fri, 12 Aug 2016 18:53:00 +0000 Message-ID: <28F9AA5F-700A-4071-B822-7977B6FAD0AD@whitepages.com> References: <8d5d6177-6cdb-faf9-4bf5-ded9cb81a601@sematext.com> In-Reply-To: <8d5d6177-6cdb-faf9-4bf5-ded9cb81a601@sematext.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/f.18.0.160709 x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [192.168.2.55] Content-Type: text/plain; charset="utf-8" Content-ID: <7C7BE334DCE251409E4ACA16F24D217F@whitepages.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 archived-at: Fri, 12 Aug 2016 18:53:00 -0000 VGhhbmtzIEVtaXIuIEnigJltIHVuZm9ydHVuYXRlbHkgYWxyZWFkeSB1c2luZyBhIHJvdXRpbmcg a2V5IHRoYXQgbmVlZHMgdG8gYmUgYXQgdGhlIHRvcCBsZXZlbCwgc2luY2UgSeKAmW0gY29sbGFw c2luZyBvbiB0aGF0IGZpZWxkLiANCg0KQWRkaW5nIGEgc3ViLWtleSB3b27igJl0IGhlbHAgbXVj aCBpZiBteSB0aGVvcnkgaXMgY29ycmVjdCwgYXMgZXZlbiBhIHNpbmdsZSBzaGFyZCAoZGlzdHJp Yj1mYWxzZSkgc2hvd2VkIHNlcmlvdXMgcGVyZm9ybWFuY2UgZGVncmFkYXRpb24sIGFuZCBxdWVy eSBsYXRlbmN5IGlzIHRoZSBtYXgoc2hhcmQgbGF0ZW5jeSkuIEnigJlkIG5lZWQgYSByb3V0aW5n IHNjaGVtZSB0aGF0IGFzc3VyZWQgdGhhdCBhIGdpdmVuIHNoYXJkIGhhcyAqb25seSogQeKAmXMs IG9yICpvbmx5KiBC4oCZcy4NCg0KRXZlbiBpZiBJIGNvdWxkIHVzZSDigJxwZXJtaXNzaW9uc+KA nSBhcyB0aGUgdG9wLWxldmVsIHJvdXRpbmcga2V5IHRob3VnaCwgdGhpcyBpcyBhIHZlcnkgbG93 IGNhcmRpbmFsaXR5IGZpZWxkLCBzbyBJ4oCZZCBleHBlY3QgdG8gZW5kIHVwIHdpdGggdmVyeSBs YXJnZSBkaWZmZXJlbmNlcyBiZXR3ZWVuIHRoZSBzaXplcyBvZiB0aGUgc2hhcmRzIGluIHRoYXQg Y2FzZS4gVGhhdOKAmXMgZmluZSBmcm9tIGEgU29sckNsb3VkIHF1ZXJ5IHBlcnNwZWN0aXZlIG9m IGNvdXJzZSwgYnV0IGl0IG1ha2VzIGZvciBtb3JlIGRpZmZpY3VsdCByZXNvdXJjZSBwcm92aXNp b25pbmcuDQoNCg0KT24gOC8xMi8xNiwgMTozOSBBTSwgIkVtaXIgQXJuYXV0b3ZpYyIgPGVtaXIu YXJuYXV0b3ZpY0BzZW1hdGV4dC5jb20+IHdyb3RlOg0KDQogICAgSGkgSmVmZiwNCiAgICANCiAg ICBJIHdpbGwgbm90IGNvbW1lbnQgb24geW91ciB0aGVvcnkgKHdpbGwgbGV0IHRoYXQgdG8gZ3V5 cyBtb3JlIGZhbWlsaWFyIA0KICAgIHdpdGggTHVjZW5lIGNvZGUpIGJ1dCB3aWxsIHBvaW50IHRv IG9uZSBhbHRlcm5hdGl2ZSBzb2x1dGlvbjogcm91dGluZy4gDQogICAgWW91IGNhbiB1c2Ugcm91 dGluZyB0byBzcGxpdCBkb2N1bWVudHMgd2l0aCBkaWZmZXJlbnQgcGVybWlzc2lvbiB0byANCiAg ICBkaWZmZXJlbnQgc2hhcmRzIGFuZCB1c2UgY29tcG9zaXRlIGhhc2ggcm91dGluZyB0byBzcGxp dCAiQSIgKGFuZCBtYXliZSANCiAgICAiQiIgYXMgd2VsbCkgZG9jdW1lbnRzIHRvIG11bHRpcGxl IHNoYXJkcy4gVGhhdCB3aWxsIG1ha2Ugc3VyZSBhbGwgZG9jIA0KICAgIHdpdGggdGhlIHNhbWUg cGVybWlzc2lvbiBhcmUgb24gdGhlIHNhbWUgc2hhcmQgYW5kIG9uIHF1ZXJ5IHRpbWUgb25seSAN CiAgICB0aG9zZSB3aWxsIGJlIHF1ZXJpZWQgKGxlc3Mgc2hhcmRzIHRvIHF1ZXJ5KSBhbmQgdGhl cmUgaXMgbm8gbmVlZCB0byANCiAgICBpbmNsdWRlIHRlcm0gcXVlcnkgb3IgZmlsdGVyIHF1ZXJ5 IGF0IGFsbC4NCiAgICANCiAgICBIZXJlIGlzIGJsb2cgZXhwbGFpbmluZyBiZW5lZml0cyBvZiBj b21wb3NpdGUgaGFzaCByb3V0aW5nOiANCiAgICBodHRwczovL3NlbWF0ZXh0LmNvbS9ibG9nLzIw MTUvMDkvMjkvc29scmNsb3VkLWxhcmdlLXRlbmFudHMtYW5kLXJvdXRpbmcvDQogICAgDQogICAg UmVnYXJkcywNCiAgICBFbWlyDQogICAgDQogICAgLS0gDQogICAgTW9uaXRvcmluZyAqIEFsZXJ0 aW5nICogQW5vbWFseSBEZXRlY3Rpb24gKiBDZW50cmFsaXplZCBMb2cgTWFuYWdlbWVudA0KICAg IFNvbHIgJiBFbGFzdGljc2VhcmNoIFN1cHBvcnQgKiBodHRwOi8vc2VtYXRleHQuY29tLw0KICAg IA0KICAgIE9uIDExLjA4LjIwMTYgMTk6MzksIEplZmYgV2FydGVzIHdyb3RlOg0KICAgID4gVGhp cyBpc27igJl0IHJlYWxseSBhIHF1ZXN0aW9uLCBhbHRob3VnaCBzb21lIHZhbGlkYXRpb24gd291 bGQgYmUgbmljZS4gSXTigJlzIG1vcmUgb2YgYSB3YXJuaW5nLg0KICAgID4NCiAgICA+IFRsZHIg aXMgdGhhdCB0aGUgaW5zZXJ0IG9yZGVyIG9mIGRvY3VtZW50cyBpbiBteSBjb2xsZWN0aW9uIGFw cGVhcnMgdG8gaGF2ZSBoYWQgYSBodWdlIGVmZmVjdCBvbiBteSBxdWVyeSBzcGVlZC4NCiAgICA+ DQogICAgPg0KICAgID4gSSBoYXZlIGEgdmVyeSBsYXJnZSAoc2hhcmRlZCkgU29sckNsb3VkIDUu NCBpbmRleC4gT25lIGFzcGVjdCBvZiB0aGlzIGluZGV4IGlzIGEgbXVsdGktdmFsdWVkIGZpZWxk ICjigJxwZXJtaXNzaW9uc+KAnSkgdGhhdCBmb3IgOTAlIG9mIGRvY3MgY29udGFpbnMgb25lIHBh cnRpY3VsYXIgdmFsdWUsICjigJxB4oCdKSBhbmQgZm9yIDEwJSBvZiBkb2NzIGNvbnRhaW5zIGFu b3RoZXIgZGlzdGluY3QgdmFsdWUuICjigJxC4oCdKSBJdOKAmXMgaW50ZW5kZWQgdG8gcmVwcmVz ZW50IHNvbWV0aGluZyBsaWtlIHBlcm1pc3Npb25zLCBzbyBtb3JlIHZhbHVlcyBhcmUgcG9zc2li bGUgaW4gdGhlIGZ1dHVyZSwgYnV0IG5vdCBwcmVzZW50IGN1cnJlbnRseS4gSW4gZmFjdCwgdGhl IGFkZGl0aW9uIG9mIGRvY3Mgd2l0aCB2YWx1ZSBCIHRvIHRoaXMgaW5kZXggd2FzIHZlcnkgcmVj ZW50LCBwcmV2aW91c2x5IGFsbCBkb2NzIGhhZCB2YWx1ZSDigJxB4oCdLiBBbGwgcXVlcmllcywg aW4gYWRkaXRpb24gdG8gdmFyaW91cyBvdGhlciBCb29sZWFuLXF1ZXJ5IHR5cGUgcmVzdHJpY3Rp b25zLCBoYXZlIGEgdGVybXMgcXVlcnkgb24gdGhpcyBmaWVsZCwgbGlrZSB7IXRlcm1zIGY9cGVy bWlzc2lvbnMgdj1BfSBvciB7IXRlcm1zIGY9cGVybWlzc2lvbnMgdj1BLEJ9DQogICAgPg0KICAg ID4gTGFzdCB3ZWVrLCBJIHRyaWVkIHRvIHJlLWluZGV4IHRoZSB3aG9sZSBjb2xsZWN0aW9uIGZy b20gc2NyYXRjaCwgdXNpbmcgc291cmNlIGRhdGEuIFF1ZXJ5IHBlcmZvcm1hbmNlIG9uIHRoZSBy ZXN1bHRpbmcgcmUtaW5kZXggcHJvdmVkIHRvIGJlIGFieXNtYWwsIEkgY291bGQgZ2V0IGJhcmVs eSAxMCUgb2YgbXkgcHJldmlvdXMgcXVlcnkgdGhyb3VnaHB1dCwgYW5kIGV2ZW4gdGhhdCB3YXMg YXQgbGF0ZW5jaWVzIHRoYXQgd2VyZSBvcmRlcnMgb2YgbWFnbml0dWRlIGhpZ2hlciB0aGFuIHdo YXQgSSBoYWQgaW4gcHJvZHVjdGlvbi4NCiAgICA+DQogICAgPiBJIGhvb2tlZCB1cCBzb21lIENQ VSBwcm9maWxpbmcgdG8gYSBzZXJ2ZXIgdGhhdCBoYWQgc2hhcmRzIGZyb20gYm90aCB0aGUgb2xk IGFuZCBuZXcgdmVyc2lvbiBvZiB0aGUgY29sbGVjdGlvbiwgYW5kIGV2ZW50dWFsbHkgaXQgbG9v a2VkIGxpa2UgdGhlIHNpZ25pZmljYW50IGRpZmZlcmVuY2UgaW4gcHJvY2Vzc2luZyB0aGUgdHdv IGNvbGxlY3Rpb25zIHdhcyBjb21pbmcgZnJvbSBDb25zdGFudFdlaWdodC5zY29yZXIoKQ0KICAg ID4gU3BlY2lmaWNhbGx5LCB0aGlzIGxpbmUNCiAgICA+IGh0dHBzOi8vZ2l0aHViLmNvbS9hcGFj aGUvbHVjZW5lLXNvbHIvYmxvYi8wYTFkZDEwZDUyNjIxNTNmNDE4OGRmYTE0YTA4YmEyOGVjNGNj YjYwL3NvbHIvY29yZS9zcmMvamF2YS9vcmcvYXBhY2hlL3NvbHIvc2VhcmNoL1NvbHJDb25zdGFu dFNjb3JlUXVlcnkuamF2YSNMMTAyDQogICAgPiB3YXMgZmFyIG1vcmUgZXhwZW5zaXZlIGluIG15 IHJlLWluZGV4ZWQgY29sbGVjdGlvbi4gRnJvbSB0aGVyZSwgdGhlIGNhbGwgY2hhaW4gZ29lcyB0 aHJvdWdoIGFuIExSVVF1ZXJ5Q2FjaGUsIGRvd24gdG8gYSBCdWxrU2NvcmVyLCBhbmQgZW5kcyB1 cCB3aXRoIHRoZSBleHRyYSB3b3JrIGhhcHBlbmluZyBoZXJlOg0KICAgID4gaHR0cHM6Ly9naXRo dWIuY29tL2FwYWNoZS9sdWNlbmUtc29sci9ibG9iLzBhMWRkMTBkNTI2MjE1M2Y0MTg4ZGZhMTRh MDhiYTI4ZWM0Y2NiNjAvbHVjZW5lL2NvcmUvc3JjL2phdmEvb3JnL2FwYWNoZS9sdWNlbmUvc2Vh cmNoL1dlaWdodC5qYXZhI0wxNjkNCiAgICA+DQogICAgPiBJIGRvbuKAmXQgcHJldGVuZCB0byB1 bmRlcnN0YW5kIGFsbCB0aGF0IGNvZGUsIGJ1dCB0aGUgZGlmZmVyZW5jZSBpbiBteSByZS1pbmRl eCBhcHBlYXJzIHRvIGhhdmUgc29tZXRoaW5nIHRvIGRvIGVpdGhlciB3aXRoIHRoYXQgY2FjaGUs IG9yIHRoZSBhZ2dyZWdhdGUgZG9jSWRTZXRzIHRoYXQgbmVlZCB3ZWlnaHRzIGdlbmVyYXRlZCBp cyBzaW1wbHkgbXVjaCBiaWdnZXIgaW4gbXkgcmUtaW5kZXguDQogICAgPg0KICAgID4NCiAgICA+ IEJ1dCB0aGUgcXVlcmllcyBkaWRu4oCZdCBjaGFuZ2UsIGFuZCB0aGUgZGF0YSBpcyBiYXNpY2Fs bHkgdGhlIHNhbWUsIHdoYXQgZWxzZSBjb3VsZCBoYXZlIGNoYW5nZWQ/DQogICAgPg0KICAgID4g VGhlIGRvY3VtZW50cyB3aXRoIHRoZSDigJxC4oCdIGRpc3RpbmN0IHZhbHVlIHdlcmUgYWRkZWQg cmVjZW50bHkgdG8gdGhlIGhpZ2gtcGVyZm9ybWFuY2UgY29sbGVjdGlvbiwgYnV0IHRoZSBB4oCZ cyBhbmQgdGhlIELigJlzIHdlcmUgYWxsIG1peGVkIHVwIGluIHRoZSBzb3VyY2UgZGF0YSBkdW1w IEkgdXNlZCB0byByZS1pbmRleC4gT24gYSBodW5jaCwgSSBtYW51YWxseSBvcmRlcmVkIHRoZSBk b2NzIHN1Y2ggdGhhdCB0aGUgQeKAmXMgd2VyZSBhbGwgZmlyc3QgYW5kIHJlLWluZGV4ZWQgYWdh aW4sIGFuZCBwZXJmb3JtYW5jZSBpcyBncmVhdCENCiAgICA+DQogICAgPiBIZXJl4oCZcyBteSB0 aGVvcnk6IFVzaW5nIFRpZXJlZE1lcmdlUG9saWN5LCB0aGUgdmFzdCBxdWFudGl0eSBvZiB0aGUg ZG9jdW1lbnRzIGluIGFuIGluZGV4IGFyZSBjb250YWluZWQgaW4gdGhlIGxhcmdlc3Qgc2VnbWVu dHMuIEnigJltIGd1ZXNzaW5nIHRoZXJl4oCZcyBhbiBvcHRpbWl6YXRpb24gc29tZXdoZXJlIHRo YXQgc2F5cyBzb21ldGhpbmcgbGlrZSDigJxUaGlzIHNlZ21lbnQgb25seSBoYXMgQeKAmXPigJ0u IEJ5IGluZGV4aW5nIGFsbCB0aGUgQeKAmXMgZmlyc3QsIHRob3NlIGJpZ2dlc3Qgc2VnbWVudHMg b25seSBjb250YWluIEHigJlzLCBhbmQgb25seSB0aGUgc21hbGxlc3QsIG5ld2VzdCBzZWdtZW50 cyBhcmUgdW5hYmxlIHRvIG1ha2UgdXNlIG9mIHRoYXQgb3B0aW1pemF0aW9uLg0KICAgID4NCiAg ICA+IEhlcmXigJlzIHRoZSBzY2FyeSBwYXJ0OiBBbHRob3VnaCBteSByZS1pbmRleCBpcyBub3cg cGVyZm9ybWluZyB3ZWxsLCBpZiB0aGlzIHRoZW9yeSBpcyByaWdodCwgc29tZSByYW5kb20gaW5z ZXJ0IChvciBhIGRlbGliZXJhdGUgb3B0aW1pemUpIGF0IHNvbWUgcmFuZG9tIHBvaW50IGluIHRo ZSBmdXR1cmUgY291bGQgY2FzY2FkZSBhIHNlZ21lbnQgbWVyZ2Ugc3VjaCB0aGF0IHRoZSBsYXJn ZXN0IHNlZ21lbnQocykgbm93IGNvbnRhaW4gYm90aCBB4oCZcyBhbmQgQuKAmXMsIGFuZCBwZXJm b3JtYW5jZSBzdWRkZW5seSBnb2VzIG92ZXIgYSBjbGlmZi4gSSBoYXZlIG5vIHdheSB0byBwcmV2 ZW50IHRoaXMgcG9zc2liaWxpdHkgZXhjZXB0IHRvIHN0b3AgZG9pbmcgaW5zZXJ0cy4NCiAgICA+ DQogICAgPiBNeSBjdXJyZW50IHRoaW5raW5nIGlzIHRoYXQgSSBuZWVkIHRvIHB1bGwgdGhlIHRl cm1zLXF1ZXJ5IHBhcnQgb3V0IG9mIHRoZSBxdWVyeSBhbmQgZG8gYSBmaWx0ZXIgcXVlcnkgZm9y IGl0IGluc3RlYWQuIFByb2JhYmx5IGFzIGEgcG9zdC1maWx0ZXIsIHNpbmNlIEnigJl2ZSBoYWQg YmFkIGx1Y2sgd2l0aCB2ZXJ5IGxhcmdlIGZpbHRlciBxdWVyaWVzIGFuZCB0aGUgZmlsdGVyIGNh Y2hlLiBJ4oCZZCB0ZXN0ZWQgdGhpcyBvcmlnaW5hbGx5ICh3aGVuIEkgb25seSBoYWQgQeKAmXMp LCBidXQgZm91bmQgdGhlIHBlcmZvcm1hbmNlIHdhcyBhIGJpdCB3b3JzZSB0aGFuIGp1c3QgbGVh dmluZyBpdCBpbiB0aGUgcXVlcnkuIEnigJlsbCB0YWtlIGEgYml0IHdvcnNlIGFuZCBwcmVkaWN0 YWJpbGl0eSBvdmVyIGEgYml0IGJldHRlciBhbmQgYSB0aW1lIGJvbWIgdGhvdWdoLCBpZiB0aG9z ZSBhcmUgbXkgY2hvaWNlcy4NCiAgICA+DQogICAgPg0KICAgID4gSWYgYW55b25lIGhhcyBhbnkg Y29tbWVudHMgcmVmdXRpbmcgb3Igc3VwcG9ydGluZyB0aGlzIHRoZW9yeSwgSeKAmWQgY2VydGFp bmx5IGxpa2UgdG8gaGVhciBpdC4gVGhpcyBpcyB0aGUgZmlyc3QgdGltZSBJ4oCZdmUgZW5jb3Vu dGVyZWQgYW55dGhpbmcgYWJvdXQgaW5zZXJ0IG9yZGVyIG1hdHRlcmluZyBmcm9tIGEgcGVyZm9y bWFuY2UgcGVyc3BlY3RpdmUsIGFuZCBpdCBiZWNvbWVzIGEgZ2VuZXJhbC1mb3JtIHF1ZXN0aW9u IGFyb3VuZCBob3cgdG8gaGFuZGxlIGxvdy1jYXJkaW5hbGl0eSBmaWVsZHMuDQogICAgPg0KICAg IA0KDQo=