How live aggregate projections affect system performance?

spektomspektom
in General Discussion

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!

Comments

  • [Deleted User][Deleted User] ✭

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...