Depending on whether or not your member and product tables are changed often, the MySQL Query Cache might be an interesting feature for you.
It caches the result sets for queries once they are processed and delivers them from the cache for some time. You can set the refresh time to a longer span, if your tables change less often, so you will benefit from the cached results for longer.
Refreshes to the cache could then be done by a script which is triggered from a Cronjob or something else. I use something similar to create full page cache versions of a website and only refresh the cache every hour or so.
StackOverflow has some interesting questions on this topic, too. You might start here: PHP Best way to cache MySQL results?