Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 82708 invoked from network); 30 Oct 2010 02:27:34 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 30 Oct 2010 02:27:34 -0000 Received: (qmail 80456 invoked by uid 500); 30 Oct 2010 02:27:33 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 80411 invoked by uid 500); 30 Oct 2010 02:27:33 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 80403 invoked by uid 99); 30 Oct 2010 02:27:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 30 Oct 2010 02:27:33 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of adam.kocoloski@gmail.com designates 209.85.213.52 as permitted sender) Received: from [209.85.213.52] (HELO mail-yw0-f52.google.com) (209.85.213.52) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 30 Oct 2010 02:27:26 +0000 Received: by ywf7 with SMTP id 7so2531742ywf.11 for ; Fri, 29 Oct 2010 19:27:05 -0700 (PDT) Received: by 10.229.249.212 with SMTP id ml20mr12447277qcb.119.1288405625505; Fri, 29 Oct 2010 19:27:05 -0700 (PDT) Received: from [10.0.1.7] (c-71-232-49-44.hsd1.ma.comcast.net [71.232.49.44]) by mx.google.com with ESMTPS id w5sm1153413vcr.6.2010.10.29.19.27.02 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 29 Oct 2010 19:27:04 -0700 (PDT) Content-Type: text/plain; charset=windows-1252 Mime-Version: 1.0 (Apple Message framework v1081) Subject: Re: Optimal _id Length From: Adam Kocoloski In-Reply-To: Date: Fri, 29 Oct 2010 22:27:00 -0400 Content-Transfer-Encoding: quoted-printable Message-Id: <3EBBB414-ED15-4228-9F9C-D8AA848B7FD5@apache.org> References: <4CCB2395.4020402@ntlworld.com> To: user@couchdb.apache.org X-Mailer: Apple Mail (2.1081) X-Virus-Checked: Checked by ClamAV on apache.org If I recall correctly, the web server embedded in CouchDB has an 8k URL = length limit. Adam On Oct 29, 2010, at 4:28 PM, Zachary Zolton wrote: > CouchDB has a max length of 4GB of JSON for the whole, but it's > configurable. Hopefully, your IDs wont brush up against that limit! >=20 > Also, here's another tidbit about IDs and their affect on performance: > http://wiki.apache.org/couchdb/Performance#A_id >=20 > =97Zach >=20 > On Fri, Oct 29, 2010 at 2:42 PM, Ian Hobson = wrote: >> On 29/10/2010 09:40, Zdravko Gligic wrote: >>>=20 >>> Hi Folks, >>>=20 >>> (1) How long can _id value be? >>=20 >> If it will handle anything longer than a UUID - and that would be = easy to >> test with a running system - then I expect there is no practical = limit. >>>=20 >>> (2) Is there an optimal length - performance wise ? >>=20 >> Yes - its what fits your application best. >>=20 >> Any performance change from optimisation will be so small it will be = hard to >> measure. The costs of complicating your app to do it, however will be = *much* >> larger and easy to measure. >>=20 >> Regards >>=20 >> Ian >>>=20 >>> Thanks, >>> teslan >>>=20 >>>=20 >>> ----- >>> No virus found in this message. >>> Checked by AVG - www.avg.com >>> Version: 10.0.1153 / Virus Database: 424/3225 - Release Date: = 10/28/10 >>>=20 >>>=20 >>=20 >>=20