Hello Ahmed
would you mind sharing your table schema.
To help on performance you should try:
- to have your most common query columns in your rowkey
- try to use different column families to distribute load
- try to se salt buckets for a good distribution
- you could also check you cache settings on the hbase side.
regards
________________________________________
From: Ahmed Hussien <aahussi...@gmail.com>
Sent: Tuesday, November 25, 2014 7:26 AM
To: dev@phoenix.apache.org
Subject: performance advice required
Good Day to you guys,
I have a db that contains about 33 million records per table (4 tables).
when i execute the following queries it takes to much time to retrieve
about 5 miniutes per query.
1- select "Records"."Operation", "Records"."status",
"Records"."timestamp" from "History" where "Records"."timestamp"=(SELECT
MAX("Records"."timestamp") FROM "History" where "rowId" like ?)
can you help me adjust the performance?
---
Ahmed
