Forum Discussion

jmvidal's avatar
jmvidal
Icon for Helper II rankHelper 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
    Icon for Helper II rankHelper 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
        Icon for Helper II rankHelper II
        6 years ago

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