Thread

Hi there,

We recently implemented a number of changes to our templates and EE structure (e.g. removing a large number of custom fields from active use, moving away from complex php in our templates in favour of a handful of little plugins). The template changes were such that we saw some drag on front-end page load times, something that has now been returned to normal by simplifying queries (e.g. making more use of the ‘disable’ parameter in the exp:weblog:entries tag). Page load times are now back to normal.

However, a day or so after these changes, all updates to the database via the Control Panel and SAEF started to suffer from the following problem: users hit ‘Update’, the content is successfully changed in the database (e.g. new entry recorded, template updated), but the page does not reload. It toils away indefinitely as if still trying to submit.

We’ve tried disabling all extensions that intercept on submission, without impact. Moreover this problem is affecting submission of templates and other information—not just weblog entries.

As I say, front-end processing is now back to normal speeds—as indeed is backend, in all situations except saving content. This doesn’t appear to be a database performance problem; nor does it seem to be a problem with extensions (as I said, this is affecting template updates as well as entry submission/editing).

Does anyone have any idea what might be causing this?

Hope someone can help, thanks,
Rob

Rob:

First thing to try.  Could you go to:  Admin ›  System Preferences ›  Security and Session Preferences and turn off secure form processing, if you have it on.

You also might want to try to optimize & repair tables in the db, which you can do here:  Admin ›  Utilities ›  SQL Manager ›  Manage Database Tables

~greg

Thanks, Greg. I’ve tried both of those things for the last 24 hours, but we’re still seeing the drag. What’s strange is that it’s also on template submission, not just entries. That would seem to rule out things like extensions to me—and indeed disabling any extensions that intercede on entry submission didn’t make any difference.

The cleanup we’ve been doing for the last few days has reduced our database size from 1.2 GB to 580 MB—I was hoping that that would help, but unfortunately not.

Any further ideas?

What version of EE are you using? Are you saving your templates as files? It sounds like it might be a “simple” database issue.

Hi Ingmar,

We’re running 1.6.7, build 20090211. Templates aren’t saved as files.

Not sure what you mean by a ‘simple’ issue—I’d be grateful for any insight you can offer!

Rob

can you go to:  Admin ›  System Preferences ›  Output and Debugging Preferences and turn template debugging and display sql queries “on”.  Then on one of the slow pages, please copy the output into a text file, zip it, and post here to the forum in your response.

Thanks,

-greg

Hey Greg,

We’re not actually seeing any problems at all now with templates. Instead, it’s on system Control Panel pages. The page display is zippy and everything is as normal. However, when a user submits/updates an entry or a template, the appropriate database updates are made but the page toils indefinitely. As a result, users are unsure if their changes have been accepted and in some cases continue to click ‘submit’.

I’ve tried looking via template debugging and sql queries, but because we aren’t getting a page reload, these aren’t revealing anything. :(

Rob

Rob, how much memory is allocated to PHP?

EEWiki:// HowTo Determine Memory Limits

Hi Sue,

It’s 64M—both local and master.

Rob,

Have you tried a different browser/machine to rule that out?

Can you deleted your cache since all you updates?

Via FTP, delete all files inside the system/cache folder except for the index.html file