Thank you. That makes sense. I guess the question is how reliable SQLite is in being able to estimate what would be faster. I thought it would always be faster to cache the results of the view, but I guess not. I will look at the documentation on EXPLAIN and see what I can make of it. Thanks again.