Skip to main content

How live aggregate projections affect system performance?

  • September 10, 2015
  • 1 reply
  • 10 views
spektom

Hello,

 

I'm trying to figure out what EC2 instance type to choose for a workflow, which mainly involves several live aggregate projections. Is Vertical handling live aggregate projections a CPU or memory intensive task?

 

Thanks!

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • September 11, 2015

    LAP are calculated when loading the data so the query should be faster and do nto use CPU or MEM. However, the load will be slower.

    This is an example of performance :

     

     

    20M meters reporting at 5-minute intervals, 1 day, Single node

    Description

    7.0.1

    7.1.0

    LAP

    Load Time

    8959

    8448

    9647

    Q1: Total Number of Readings (time range)

    4.5

    4.5

    0.08

    Q2: Total Consumption (time range)

    0.23

    0.21

    0.02

    Q3: Peak Consumption

    0.18

    0.28

    0.03

    Q4: Top Consumers

    482

    545

    3.13

    Q5: Consumption Timeseries

    0.37

    0.28

    0.17

    Q6: Time-of-use Billing

    581

    684

    7.0

     

     

    Hope this helps,

     

    Eugenia

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement