My sql query was taking around 2 minutes to execute . I was having a shared hosting environment . Due to some memory problems i have to change the host and shifted to VPS with 1 gb ram and 300 mhz cpu speed . But my problem is that the same query is taking now around 15 minutes to execute acting on same no of records . My vps host says that everything is fine . Can anybody help me - what would be the actual reason for that . nothing has been changed - neither query nor records but hosts are changed