Hi,
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.
Any help I would be gratefull to you.
Thanks