Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hbase-user@hadoop.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=yVWcrMq9FAYIJoo5kgTfj2gFCsR2m9SViDgzAWs+JzS4iR2J/AlQwU3MT2YOyIcHIedIjNoF3hYxdVHao7yjnK7dKztUCYRPgjRFn1y4Nz0zcYdY7mJ+rSDSbkdNoy55i8d/YXsrz49HHlKWynDldfty5LuFiuVgtyH4NWYjymk=;
Date: Thu, 7 Feb 2008 16:19:30 -0800 (PST)
From: Charles Kaminski <freeav8r@yahoo.com>
Reply-To: freeav8r@yahoo.com
Subject: Re: Evaluating HBase 3
To: hbase-user@hadoop.apache.org
In-Reply-To: <47AB9E25.4050008@duboce.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <38089.48182.qm@web34213.mail.mud.yahoo.com>

Hi St.Ack,

Thanks for the response.  The performance changes
below are consistent with what we find in our java
app.  We used Hbase Shell directly on the server to
rule out anything we might be doing wrong.


--- stack <stack@duboce.net> wrote:

> You are using the shell to do your fetching?  Try
> writing a little java 
> program.
> St.Ack
> 
> 
> Charles Kaminski wrote:
> > Hi All,
> >
> > We're running into sever performance issues.  I'm
> > hoping that there is something simple we can do to
> > resolve the issues.  Any help would be
> appreciated.
> >
> > Here's what we did:
> > 1.  Loaded 1,000 records into a table with only
> two
> > columns - row and content:.  Row data is 12 bytes
> and
> > content: data is 23 bytes long.
> > 2. Using HBase, selected a single record based on
> row
> > in the where clause.  Did this for a few different
> > records.  Performance was consistantly 0.01
> seconds as
> > reported by Hbase.
> > 3. Loaded 1,000,000 records into the same table. 
> This
> > took 248 seconds using random row values.
> > 4. Ran the exact same select statments again as in
> > step 2.  These consistantly took 2 to 3 seconds to
> > return a single record.
> >
> > 2 to 3 seconds to return a single record using a
> key
> > value suggests a major issue with our setup.  I'm
> > hoping you agree and can point us to something
> we're
> > doing wrong.
> >
> >
> >
> >
> >
> >
> >      
>
____________________________________________________________________________________
> > Looking for last minute shopping deals?  
> > Find them fast with Yahoo! Search. 
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >   
> 
> 


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ