couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zachary Zolton <zachary.zol...@gmail.com>
Subject Re: Optimal _id Length
Date Sat, 30 Oct 2010 03:54:59 GMT
Good to hear something that would affect the practical upper bounds of
ID length...

Real question is: how short of an ID makes a difference on database
file size before the improvements are unnoticeable WRT to the rest of
the documents' overhead? Would make a fun test.

—Zach

On Fri, Oct 29, 2010 at 9:27 PM, Adam Kocoloski <kocolosk@apache.org> wrote:
> 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!
>>
>> Also, here's another tidbit about IDs and their affect on performance:
>> http://wiki.apache.org/couchdb/Performance#A_id
>>
>> —Zach
>>
>> On Fri, Oct 29, 2010 at 2:42 PM, Ian Hobson <ian.hobson@ntlworld.com> wrote:
>>> On 29/10/2010 09:40, Zdravko Gligic wrote:
>>>>
>>>> Hi Folks,
>>>>
>>>> (1) How long can _id value be?
>>>
>>> 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.
>>>>
>>>> (2) Is there an optimal length - performance wise ?
>>>
>>> Yes - its what fits your application best.
>>>
>>> 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.
>>>
>>> Regards
>>>
>>> Ian
>>>>
>>>> Thanks,
>>>> teslan
>>>>
>>>>
>>>> -----
>>>> 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
>>>>
>>>>
>>>
>>>
>
>

Mime
View raw message