Forum Discussion

jmvidal's avatar
jmvidal
Helper II
6 years ago
Solved

Should I split tables by year?

Hi, I am starting from scratch my dataset and have a common structure of: Order lines Delivery note lines Invoice line since many years ago.   I was wondering if it makes sense to split thos...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    jmvidal I am doing this with transaction data: 2015 to 2019 data is static and then 2020 data is refreshed. Then I use the UNION command. It makes the data refresh much faster.

jmvidal's avatar
jmvidal
Helper II
6 years ago

Thank you Anonymous !

After reading the article looks like it is not a common way to deal with large data series when you just need to update recent info.

I thought it would be a more popular request...

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

jmvidal I am doing this with transaction data: 2015 to 2019 data is static and then 2020 data is refreshed. Then I use the UNION command. It makes the data refresh much faster.

  • jmvidal's avatar
    jmvidal
    Helper II
    6 years ago

    Thanks, that makes sense. That's definitely what I'm going to try.