On Sun, Mar 11, 2018 at 10:33 AM, dangal <danielito.ga...@gmail.com> wrote:
> jeff thank you very much for your time, I tell you, they are the same > queries > with the same parameters, I take 3 minutes for example, but I execute it > and > it takes me seconds, that's why I suspect it is the shared buffer > The server had 16 GB and we increased it to 24, but I really do not know if > it should continue to increase since they are not our own resources, we > have > to ask for them and justify them > If that is the only query that you have trouble with, it might be easiest just to set up a cron job to run it periodically just to keep that data set in cache. Not very elegant, but it can be effective. Cheers, Jeff
