[ https://issues.apache.org/jira/browse/PHOENIX-1073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-1073. ----------------------------------- Resolution: Invalid > A memory table in every region is needed? > ----------------------------------------- > > Key: PHOENIX-1073 > URL: https://issues.apache.org/jira/browse/PHOENIX-1073 > Project: Phoenix > Issue Type: Wish > Reporter: jay wong > > When a do a group by query. > We assume that a Region has 30M data. > 100K row which include 30 kv per row > And the RT of GroupedAggregateRegionObserver is about 3 sec. > but most of time. in fact nearly 2.2 sec is spend on RegionScaner scan all > the row. > I have a test. first time scan all of the data into memory. > the second time only load the data from memory. > the RT of GroupedAggregateRegionObserver execute only 0.7s. > So If a memory table is needed for Phoenix computational intensive scene -- This message was sent by Atlassian JIRA (v6.2#6252)