Prakrati, I'm new to HBase myself, but I could interpret your results as 1) Enabling caching would only decrease retrieval time over time. I.e. once you start retrieving the same rows over and over again. I'm not sure from your results that your tests are actually trying to retrieve cached results. 2) If 1) isn't true, then you wouldn't expect any improved retrieval time from your queries with caching enabled. However, I could believe that retrieval time would go up slightly because you've now enabled caching, which means for every request, you have to insert data into the cache.
Again, I'm just making some guesses based on the info provided. HTH, Minh On Mon, Jun 25, 2012 at 2:11 AM, Prakrati Agrawal <prakrati.agra...@mu-sigma.com> wrote: > Dear all > > I am trying to optimize the retrieval code in Java for HBase. The following > are the timings without cache enabled: > The time taken to get 175347 columns of a row key is 677 ms > The time taken to get rows : 99 and columns: 14888573 is 48806 ms > The time taken to get all data (rows: 396 and columns: 32611576) is 96469 ms > > The time taken after caching is enabled(Both block and setCaching) : > The time taken to get 175347 columns of a row key is 713 ms > The time taken to get rows : 99 and columns: 14888573 is 57649 ms > The time taken to get all data (rows: 396 and columns: 32611576) is 111056 ms > > As you all can see, time increases after I enable caching. I am not > understanding what I am doing wrong. Please help me > > Thanks and Regards > Prakrati > > > ________________________________ > This email message may contain proprietary, private and confidential > information. The information transmitted is intended only for the person(s) > or entities to which it is addressed. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, this > information by persons or entities other than the intended recipient is > prohibited and may be illegal. If you received this in error, please contact > the sender and delete the message from your system. > > Mu Sigma takes all reasonable steps to ensure that its electronic > communications are free from viruses. However, given Internet accessibility, > the Company cannot accept liability for any virus introduced by this e-mail > or any attachment and you are advised to use up-to-date virus checking > software.
