Site Is So Slow!

[eluser]Hockeychap[/eluser]
Just a couple of quick thoughts on the mysql front:

1. How is the comparison being done for the existing data ?. It may be worth looking at the insert ..on duplicate key update syntax as a quicker way of doing things as the update statement will not actually do any updates in the data is the same.

2. Temporarily turn on the slow , error and possibly query log files to see what's causing you pain. (it's worth checking the slow_queries varible to see if you have any slow queries first).

3. Check the indicies that you use on the tables. People commonly miss off secondary indicies. The query log is a good place to start to see what's actually happening (although it can get quite large quite quickly fast).

I'd recommend cloning your database to a local machine if possible as you can then run through the app, turn on the log files etc without impacting your production setup.

If nothing comes up there it's also worth looking in slightly more detail at the db set to make sure it's reasonably well tuned for the number of connections that you are running.

Hope this helps