Site Slow Data Base Optimize the queries and connections

My site is slow because of the data base scripts need to be optimized and the queries and connections. I think the connections are not closing so it has too many queries open. Does anyone know how to turn off the connections? Does anyone know how to fix this issue (I can pay for the help.)

Thanks,
Gail

you can optimize database by adding more index.

How do you add more index?

The host says the data base has too many queries open. Does anyone know how to turn off the connections? Does anyone know how to fix this issue (I can pay for the help.)

Yeah, move to a better host.

It has nothing to do with the host. I has to do with the connections for the scripts not closing. The SEO and site speed scripts MOD that I bought on Opencart

gail315 wrote:It has nothing to do with the host. I has to do with the connections for the scripts not closing. The SEO and site speed scripts MOD that I bought on Opencart

I don't understand your last sentence. You bought an SEO and site speed scripts MOD from the extensions store? Is it causing the errors your are complaining about? If so why not contact the developer directly? Or are you saying you bought the mod and it fixed the problem?

Well, 503 error seems to be hosting error.
But were u able to fix it without changing ur host gail315?

Did u learn how to close those connections?

I switched to a better host.

and my client payed for 2 year straight up to godaddy!