Options

Calculate average of large data

phmandawaphmandawa
in General Discussion

 

HI,

 

I am trying to calculate avg for 10 gb data and show it on graph in browser. Query takes around 16 sec. For smaller chunk of data, it is around 1 sec. Should I divide the table into multiple partitions and run queries in parallel. Or Am I missing something.

 

 

 

Comments

  • Options
    emorenoemoreno Employee

    Can you show the explain plan of the statement that you are trying to do the average? Do 

     

    explain select avg(xxx)..... 

     

    I would like to see if you have specific aggregatons and the projections that you are using. 

     

    Eugenia 

  • Options
    phmandawaphmandawa

    HI,

     

    Thanks for your reply, It is simple query for calculating moving average. The query time is now less than 1 sec. I took the help of db designer and it asked me to create a new projection.

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 ...