As I’m going through my project I’m looking at places in my application that are causing pages to load longer than perhaps they should. I’m finding some queries that execute for my page navigation that happen each time a page reloads, but their information that is returned doesn’t usually change. An example I have would be I display 32 NFL Club logos that serve as links to each clubs page in my navigation. The query looks like this:
SELECT [clubs].* FROM [clubs] WHERE (clubs.is_disabled = 0) ORDER BY [clubs].[city] ASC;
Now this code runs in development and it's saying it takes 32.9ms to execute. But to my point these 32 clubs rarely change. Is there a different approach I should be taking to this other than having it run on every page request? Thanks!