Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 64264 invoked from network); 1 Feb 2011 08:54:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Feb 2011 08:54:35 -0000 Received: (qmail 81455 invoked by uid 500); 1 Feb 2011 08:54:33 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 80906 invoked by uid 500); 1 Feb 2011 08:54:30 -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 80898 invoked by uid 99); 1 Feb 2011 08:54:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Feb 2011 08:54:28 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [80.203.160.34] (HELO gatekeeper.vizrt.com) (80.203.160.34) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Feb 2011 08:54:20 +0000 Received: from VizrtFinancePC (10.211.8.136) by MAILBGO.vizrt.internal (192.168.110.25) with Microsoft SMTP Server (TLS) id 8.3.137.0; Tue, 1 Feb 2011 09:53:57 +0100 From: Panop S. To: Subject: Deleting Document Date: Tue, 1 Feb 2011 15:53:49 +0700 Message-ID: <000b01cbc1ed$902cb4d0$b0861e70$@vizrt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01CBC228.3C8DAFB0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcvB6s+IQrU4hHOFTf2N2JgEjuibtw== Content-Language: en-us X-Virus-Checked: Checked by ClamAV on apache.org ------=_NextPart_000_000C_01CBC228.3C8DAFB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I have design a document in couchdb like a tree file structure as 1 |--2 | |--4 | |--3 Doc id : 2 Parent: 1 Doc id : 3 Parent: 1 Doc id : 4 Parent: 1 So when I query I emit it by parent Id . Then when get /id/1 , I will get docid = 2 ,3 So if I would like to delete 1 require 2 steps in C# application by using recursive call. 1. querying /id/1 and issue get command id = 2 and issue delete command id = 2 2. querying /id/2 and issue get command id = 4 and issue delete command id = 4 The problem is if there are a lot of documents it is slow down performance by recursive in C# code and query by loading huge documents and the others client request cannot process. As I can think of now for a lot of document by using &limit=some number to reduce a lot of tons Of document to be load. And also Can I write some operation to delete indexed id on javascript of couchdb ? if so, is this good idea ? Any Idea ? Big Thanks, ------=_NextPart_000_000C_01CBC228.3C8DAFB0--