Thread

Hi there,

Been trying for a while to figure this one out, but nothing is working. We have an EE site that was just launched and is working very slow - was lightning fast on the development server.

We’ve put in all the cache stuff and removing the unnecessary queries stuff, and that has improved things, but when when it is actually loading everything to write the cache, it takes from 7-23 seconds according to the profiler.

In the Template debugger, we see this over and over again:

(0.575854)       -> Method Called: entries
(1.752673)       -> Data Returned

A large jump in execution time for calling the “entries” method when running the channels. Has anyone experienced this? Is it indicative of a MySQL problem maybe? I know that there are queries in the entries function.

If you run the same query that EE does in PHPMyAdmin on that same server, does it still take as long to load?

Here is an example query from the profiler.

2.7822       SELECT *
FROM (`exp_online_users`)
WHERE `site_id` = '1'
AND `date` > 1289859979
ORDER BY `name`

In PHPmyAdmin it took .00007 seconds and in Sequel Pro it says like 52ms.

There are plenty of queries like this (this was on a very long page load). Hmm…

All I can think of right now is to run ‘Optimize tables’ or ‘Repair tables’ on the database. (Tools > Data > SQL Manager > Manage Database Tables). Other than that, I have no clue…

Greetz,
Wouter

Still nothing - 5-6 seconds for every page load. Something tells me it is a problem with the host.

I don’t think it’s the host itself as PHPMyAdmin and SQL Pro works as usual.

How much memory do you have available for PHP?

PHP Info says 128MB.

Should be more than enough… so I’m at a loss.

What server environment are we working with here? Also, have you seen these tips in the wiki?