Thanks James,
I will test with this tool and report back.
Sumit
From: James Taylor <[email protected]>
To: user <[email protected]>; Sumit Nigam <[email protected]>
Sent: Monday, September 21, 2015 11:52 AM
Subject: Re: Local and global indexes
Hi Sumit,Every use case is different, that's why we created the Pherf tool[1]
so you could try representative data sets over various different variations in
schema in a multi threaded environment. Please share what you find with us so
the community can build up this knowledge.Thanks,James
[1] https://phoenix.apache.org/pherf.html
On Sun, Sep 20, 2015 at 10:09 PM, Sumit Nigam <[email protected]> wrote:
Hi,
I had some doubt about local vs global indexes in Phoenix.
In my use case, I have both read and write heavy use cases against the same
tables. So, is it a better idea to use local indexes?It is also going to help
reduce network chatter.
Plus, my reads may issue queries which fetch non-indexed columns as well.
Should I keep both global and local indexes on the same secondary index column?
Thanks,Sumit
