I have an app that has 3 virtual columns that are taking around a second each. There are 30k rows in this table so aside from cutting down the rows, which I am also working on, does anyone have any tips for making these columns less expensive? The columns are a lookup of another table in my app, I have a concatenated column of the 3 that I need already so would pulling that column and splitting it be faster than 3 lookups? These values are based on a foreign key that can be changed so adding them to the original table is not an option.
LinkedIn
Twitter
