--- Jim Kellerman, Powerset (Live Search, Microsoft Corporation)
> -----Original Message----- > From: Dru Jensen [mailto:[email protected]] > Sent: Monday, December 15, 2008 6:10 PM > To: [email protected] > Subject: Performance Issue > > I have an HBase table that stores calculated values for different > dates and locations. This table only has 4 column families but with > the combination of dates and locations generates 90K+ columns per > row. The values stored are 4 characters long like "43.25". Reading > the BigTable document, I decided to allow the number of columns to > grow to large numbers. > > When I perform a get() on a single row, the results take 2 minutes to > return. I was hoping for second response times. At first I thought > this was related to the number of row in the table so I retried this > with a table only having 1 row in it and the results were the same. > > Any ideas on how to fix this? > > Example: > > key=John Doe > column:CA|2008-01-01 value=32.53 > column:CA|2008-01-02 value=32.54 > column:CA|2008-01-03 value=32.55 > column:CA|2008-01-04 value=32.56 > column:CA|2008-01-05 value=32.57 > column:CA|2008-01-06 value=32.58 > ...90,000+ > > Thanks for you help! > Dru Jensen
