Hi Kiran When you say doing a batch get with 20 Gets, whether the rowkeys for these 20 Gets are in same region? How many RS you are having? Can u observer out of this 20, which all gets targetting which all regions..... Some information on this can help explain the slowness...
-Anoop- ________________________________________ From: kiran [kiran.sarvabho...@gmail.com] Sent: Wednesday, March 06, 2013 10:36 AM To: user@hbase.apache.org Subject: Re: Miserable Performance of gets Version is 0.94.1 Yes, the gets are issued against the second table scanning the first table On Wed, Mar 6, 2013 at 10:27 AM, Ted Yu <yuzhih...@gmail.com> wrote: > Which HBase version are you using ? > > bq. But even for 20 gets > These were issued against the second table ? > > Thanks > > On Tue, Mar 5, 2013 at 8:36 PM, kiran <kiran.sarvabho...@gmail.com> wrote: > > > Dear All, > > > > I had some miserable experience with gets (batch gets) in hbase. I have > two > > tables with different rowkeys, columns are distributed across the two > > tables. > > > > Currently what I am doing is scan over one table and get all the rowkeys > in > > the first table matching my filter. Then issue a batch get on another > table > > to retrieve some columns. But even for 20 gets, the performance is like > > miserable (almost a second or two for 20 gets which is not acceptable). > > But, scanning even on few thousands of rows is getting completed in > > milliseconds. > > > > My concern is for about 20 gets if it takes second or two, > > How can it scale ?? > > Will the performance be the same even if I issue 1000 gets ?? > > Is it advisable in hbase to avoid gets ?? > > > > I can include all columns in only one table and do a scan also, but > before > > doing that I need to really understand the issue... > > > > Is scanning a better solution for scalability and performance ??? > > > > Is it advisable not to do joins or normalizations in NOSQL databases, > > include all the data in only table and not do joins with another table ?? > > > > > > -- > > Thank you > > Kiran Sarvabhotla > > > > -----Even a correct decision is wrong when it is taken late > > > -- Thank you Kiran Sarvabhotla -----Even a correct decision is wrong when it is taken late