We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


What's the best way to store calculated data in a database? — Vertica Forum

What's the best way to store calculated data in a database?

WyattKaiWyattKai Community Edition User
edited June 2021 in General Discussion

What's the cleanest way of going about this? How often should the data in the database be recalculated / at which events should the data be recalculated.https://omegle.onl/

I'm currently trying to model upvotes in posts. I don't know if it's faster if I just sum the vote integers (0, 1, or -1) every single time a post is loaded, or if I just store the initial upvote count and just increment and decrement it, and only calculate the sum every once in a while

Answers

  • marcothesanemarcothesane - Select Field - Administrator

    If the table where you store the votes gets a new row each time a vote is made, consider a Live Aggregate Projection that contains SUM(vote) GROUP BY (<whatever_makes_sense>). This way, you don't need to store the sum, but can get it from a pre-aggregated data store every time you SELECT SUM(vote) FROM ... .

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