you have many various factors, eg. how large is database,
plugin using default oxwall mechanism to cache sql queries, base, admin plugins and default oxwall plugins created by team have implement this mechanism in code.
i recomend using file caching, because then you dont using mysql
and what setting should i use sql or file caching?