I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. i already tried using cloudflare to optimize the system but the slow querying still persist. can anybody have an idea that can help me optmize the poor performace of my database?
By the way the system is hosted in a dedicated server but the resources consumption is very high.