Search the Community
Showing results for tags 'best practice'.
I have a View based on about 6 related tables. One of these tables has about 60,000 records that span the last 20 years, which is by far the largest table. I really only need the last 5 years of data from this table for Caspio purposes, so I'm wondering if it might be worth it to archive any data in that table that's older as a means of improving performance. That said-- unless there's a huge performance boost, my preference would be to create a View that filters out all years from prior what I need.