phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mujtaba Chohan (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-1693) Stats sometimes cause query to execute more slowly
Date Tue, 03 Mar 2015 18:47:04 GMT


Mujtaba Chohan commented on PHOENIX-1693:

Sure James. I'll get more info. on this soon.

> Stats sometimes cause query to execute more slowly
> --------------------------------------------------
>                 Key: PHOENIX-1693
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
> After initial data load with Phoenix 4.3.0 with stats enabled for 500M FHA table using
Pherf, aggregate count queries over 5% or 15% of total rows are some times 2-5X slow compared
to queries without stats. Needs to investigate the root cause. 
> Observations:
> * After major compaction with new stats are re-generated and queries become fast compared
to tables without stats.
> * Trucating stats table after initial data load also makes queries perf. comparable to
previous Phoenix release with stats disabled.

This message was sent by Atlassian JIRA

View raw message