Ok chuck, I know why the database loads so slowly, it was because when photopost was reinstalled after the impex import was done and all things were done, during the re-installation, it gave loads of mysql errors. I will attach a file in the following link just to show you the number of errors and you might get an idea or something. Please tell me what I should do now.
The photopost and IPB Databases from the old site was imported into a new database name where vbulletin was installed. Once installed, vbulletin was integrated with photopost after photopost reinstall. This gave lots of mysql errors. Any idea what I can do to cure this disease?
http://www.wheelsbd.com/errors/ppsqlbug.txt