performance numbers for single query(not reads/sec but single query)

["Hiller, Dean (Contractor)" <de...@broadridge.com>]

I read something somewhere that had performance using a self-created
index(with either lily or the tableindex or something) and it has some
numbers in there.  I was trying to redig that up since we are looking at
in-memory datagrid technology and I figured we could just use hbase
instead.  (we do a lot of batch at night plus real time
querying/updating during the day).  I remember it was in ms even though
it was using the index(one table lookup) and then getting the data from
the main table.  Any links to that?

 

I see Lily's perf. Numbers but throughput can be different than one
single io operation(ie. I can have 7000 operations all take 800ms and
still meet 7000/second like he had in the paper.  (I suspect of course
that is not the case based on what I read previously).

 

Thanks,

Dean

 


This message and any attachments are intended only for the use of the addressee and
may contain information that is privileged and confidential. If the reader of the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.

Re: performance numbers for single query(not reads/sec but single query)

[Tost <nc...@gmail.com>]

You should check like below
http://blog.rajeevsharma.in/2009/06/secondary-indexes-in-hbase.html

source samples
https://issues.apache.org/jira/browse/HBASE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

<http://blog.rajeevsharma.in/2009/06/secondary-indexes-in-hbase.html>This
might be help you.



2011/1/12 Hiller, Dean (Contractor) <de...@broadridge.com>

> I read something somewhere that had performance using a self-created
> index(with either lily or the tableindex or something) and it has some
> numbers in there.  I was trying to redig that up since we are looking at
> in-memory datagrid technology and I figured we could just use hbase
> instead.  (we do a lot of batch at night plus real time
> querying/updating during the day).  I remember it was in ms even though
> it was using the index(one table lookup) and then getting the data from
> the main table.  Any links to that?
>
>
>
> I see Lily's perf. Numbers but throughput can be different than one
> single io operation(ie. I can have 7000 operations all take 800ms and
> still meet 7000/second like he had in the paper.  (I suspect of course
> that is not the case based on what I read previously).
>
>
>
> Thanks,
>
> Dean
>
>
>
>
> This message and any attachments are intended only for the use of the
> addressee and
> may contain information that is privileged and confidential. If the reader
> of the
> message is not the intended recipient or an authorized representative of
> the
> intended recipient, you are hereby notified that any dissemination of this
> communication is strictly prohibited. If you have received this
> communication in
> error, please notify us immediately by e-mail and delete the message and
> any
> attachments from your system.
>
>