Slow load times

[hansg]

Hi,

I am having an issue loading my Campaign pages and list page. All other webpages load with normal times.

When I click to modify a campaign it is taking 20+ seconds to load. I just see a message at the bottom saying "waiting for '###.#####.com" (my domain).

I have tried to optimize the database using "mysqlcheck -o --all-databases" but it has not made any difference.

This is a new deployment and does not have a lot of data loaded.


Any advise on this would be great.

[ccabrera]

Check what your database is doing while you wait for the page to load. My best guess is the database is being held inside a slow query.

Run a "show full processlist" inside MySQL while your webpage is waiting to load. That'll give you some insight of where the problem is.

[williamconley]

if those two pages are the only two with issues, it's likely because you have a huge number of lists and/or leads. archive or delete all those not presently in use.