Constant max value

One rule of thumb that I like to utilize constants in place of reference tables with data that won't be frequently changed. This isn't transaction data you expect to change daily but lookup values that might not change for a year or more. A list of US States would be perfect as a constant and not DB.

If it has more than 100 or 200 rows, or if each row has more than 5 or 6 elements you might want to consider a DB query rather than constant. After a certain size the speed of SQL makes up for the delay in linking to it.

One rule of thumb that I like to utilize constants in place of reference tables with data that won't be frequently changed. This isn't transaction data you expect to change daily but lookup values that might not change for a year or more. A list of US States would be perfect as a constant and not DB.

If it has more than 100 or 200 rows, or if each row has more than 5 or 6 elements you might want to consider a DB query rather than constant. After a certain size the speed of SQL makes up for the delay in linking to it.