I have development server at home which i use to develop my PHP - MySQL
code. Recently I finished the database and some pages and I wanted to
move it to dedicated server at my provider. I exported whole database
using MySQL-Front and imported in on the server without problems using
mysql -u root -p < database.sql.
Everything seems to be OK but queries that take 2seconds on my machine
takes forever on my dedicated server.
Does anyone have an idea what could be the problem?
I'm using 5.0.24a-log at home and 5.0.27-log at dedicated server.