vicidial.org

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.

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.

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.