I am using MYSQL as back end with PHP CGI-version. I suppose we have around 300 users visiting site every day. At the administration side some times querying database is taking more time and some times it is very fast.I couldn't find what is the problem with the connection. I am using normal mysql_connect(). we are hosted on shared server, would this be any problem for the slowness.
Can anybody suggest how to fine tune MYSQL for the best results.
From what i've seen on other sites is that the user connects to the database more than once, since it isnt needed being that you are already connected.
I've even seen some people connect to the same db around 10 times, it just caused a really slow load time for users.
Other than that maybey someone else on the host is running scripts or is just really large and is causing your side to be slow.