Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of doug.meil@explorysmedical.com
 designates 216.32.181.184 as permitted sender)
Received-SPF: pass (mail32-ch1: domain of explorysmedical.com designates
 157.56.244.181 as permitted sender) client-ip=157.56.244.181;
 envelope-from=doug.meil@explorysmedical.com;
 helo=CH1PRD0410HT002.namprd04.prod.outlook.com ;.outlook.com ;
From: Doug Meil <doug.meil@explorysmedical.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Subject: Re: hbase delete operation is very slow
Thread-Topic: hbase delete operation is very slow
Thread-Index: AQHM8Nram4jQkB80MEGHIY7SdfIxxJZHn4MAgABzk4D//8EYAA==
Date: Wed, 22 Feb 2012 01:54:07 +0000
Message-ID: <CB69B437.25383%doug.meil@explorysmedical.com>
In-Reply-To: 
 <CADcMMgGmE7giMypzPJbbnfvORCyMGj30B6eNXL9umzB-=JgipQ@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-ID: <A3D896D5A1FC12428063590A07AA487A@namprd04.prod.outlook.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0


I don't think write-buffering is an option because that's Put-only the
last time I looked, but the advice I put in the book is to use the
delete(List<Delete>).  He'll have to keep track of the List<Delete>
himself and determine when the batch should be sent, but it's a lot better
than one at a time.


On 2/21/12 7:39 PM, "Stack" <stack@duboce.net> wrote:

>On Tue, Feb 21, 2012 at 2:45 PM, Doug Meil
><doug.meil@explorysmedical.com> wrote:
>>
>> Hi there-
>>
>> You probably want to see this...
>>
>> http://hbase.apache.org/book.html#perf.deleting
>>
>> .. that particular method doesn't use the write-buffer and is submitting
>> deletes one-by-one to the RS's.
>>
>>
>
>Do what Doug suggests.  Sounds like you are setting up a Map per row
>and then per row, figuring whether to Delete.  If a Delete, you do an
>invocation per.  Where are you getting your table instance from?  Is
>it created each time?  And as per Doug, are you write buffering your
>deletes?
>
>St.Ack
>