Jump to content

[SOLVED] Extremely slow to open / save one template type in admin


prestoav
 Share

Recommended Posts

Now solved, see reply at the bottom.

Hi all.

PW version: 3.0.42

Despite the usual speediness of PW, a site I'm working on at the moment is suffering an extremely slow load and save time in admin. We have the same site running on localhost (a brand new MacBook Pro with 3.1GHz processor / 16GB RAM) and a Media Temple VPS host both installations suffer in the same way.

All pages open and save in admin very quickly with the exception of pages using one template which just happens to be the most used one (for products the site owner manufacturers).

Opening the page to edit, or saving the page, can take more than a minute! The whole front-end of the site slows while this is happening. I should add that no caching is turned on at the moment, save the standard PW system. We are, however using the multi-language support with 6 languages installed.

The template consists of the following number/type of fields:

  • 1x PageTitleLanguage 
  • 3x TextLanguage
  • 4x Page
  • 4x Repeaters (2-3 fields, typically text / image / textarea / page, in each - up to 10 entries per repeater)
  • 1x RepeaterMatrix (3 fields in each, up to 3 entries per repeater)
  • 2x TextArea
  • 1x TextAreaLanguage
  • 3x Image
  • 8x Text

Has anyone had an experience like this before? Is this expected behaviour with this number of fields in a page (it's the first time I've used this many on one template)?

As always, any help would be gratefully received!

Link to comment
Share on other sites

wow for one i can say that is a lot of repeaters, each with a lot of fields. You probably need to ajax load the repeaters and repeater matrix fields to start, or put them all on a tab and ajax load that whole tab.

with up to 10 entries on a repeater holding text, image, textarea (is this RTE?), and page ref (how many pages, and what inputfield are you using?), i would probably have gone with page table instead, though it might work.

Also, assuming your MySQL instance is localhost? i have sometime seen some slowdowns when using MySQL hostnames, due to the additional DNS lookups; Have you tried optimizing and repairing all of the tables?

also you may want to experiment with auto join for some fields here, but be careful, sometimes autojoin can cause problems...

  • Like 2
Link to comment
Share on other sites

Hi Macrura, 

Thanks for replying. really appreciated. I'll try the AJAX loading the repeaters. From memory, they are set this way already but I'll check.

You're right in that both hosts are running the DB in localhost so no DNS in the way. Good idea though and I'll keep that in mind for the future.

Will keep looking!

Link to comment
Share on other sites

13 hours ago, Macrura said:

wow for one i can say that is a lot of repeaters, each with a lot of fields. You probably need to ajax load the repeaters and repeater matrix fields to start, or put them all on a tab and ajax load that whole tab.

with up to 10 entries on a repeater holding text, image, textarea (is this RTE?), and page ref (how many pages, and what inputfield are you using?), i would probably have gone with page table instead, though it might work.

Also, assuming your MySQL instance is localhost? i have sometime seen some slowdowns when using MySQL hostnames, due to the additional DNS lookups; Have you tried optimizing and repairing all of the tables?

also you may want to experiment with auto join for some fields here, but be careful, sometimes autojoin can cause problems...

Hi Macrura,

Looks like all the repeaters are set to AJAZ load anyway (default behaviour).

Are there any tutorials on creating a new tab in an admin page that you know of (not done that before)?

Link to comment
Share on other sites

16 hours ago, prestoav said:

Opening the page to edit, or saving the page, can take more than a minute!

While the issue of opening an Edit page being very slow can be caused by repeaters, the save operation being very slow cannot. That leads me to suspect that this issue will not be solved by moving fields to an ajax loaded tab, correct me if I'm mistaken.

Not free but if you really get stuck, this one can help: https://processwire.com/api/modules/profiler-pro/ especially since Ryan's person-to-person support comes with it as well: https://processwire.com/api/modules/profiler-pro/#here-to-help-you

  • Like 2
Link to comment
Share on other sites

3 hours ago, prestoav said:

Are there any tutorials on creating a new tab in an admin page that you know of (not done that before)?

no need for a tutorial - it's too simple ;) just add a fieldsettab to your page, save it, then you'll get a warning and a second field called yourfield_END. place your fields in between those fields and they will be presented in a tab.

there is a little issue with ajax tabs though: https://github.com/processwire/processwire-issues/issues/332

are you using tracy debugger? are you using any hooks? any modules?

 

  • Like 1
Link to comment
Share on other sites

Thanks berhard for the FieldSetTab option. Another very cool PW feature I didn't know about. That will come in useful!

Sadly though in this case it's not made any difference to the load and save page of the pages with that template, despite moving some of the 'big hitters' from the page into tabs :-(

Link to comment
Share on other sites

1 minute ago, bernhard said:

i would have been surprised if that had made a difference ;) thats why i asked this:

Ah, sorry missed that!!!

No hooks and no modules (other than core and ProFields repeater matrix) related to that template. Repeater Matrix is working on other templates OK and is only used once in the offending template.

I've not come across Tracey debugger before. Do you mean this: https://modules.processwire.com/modules/tracy-debugger/ ?

Thanks again.

  • Like 2
Link to comment
Share on other sites

yes, tracy is awesome and would recommend you having a look ;) though sometimes it slows things down a little. i also experienced that the debug mode can slow down things.

in your case i would do the following:

  • backup
  • install tracy and see if you find any strange things (errors, many redirects etc)
  • create a new template, check performance
  • if performance is ok, add fields of your slow template one by one and check after adding each field. if it slows down at some point you could investigate further
  • Like 1
Link to comment
Share on other sites

2 minutes ago, bernhard said:

install tracy

Also, with @adrian's Tracy Debugger module, you can try this to identify possible modules causing the issues: https://processwire.com/blog/posts/introducing-tracy-debugger/#module-disabler-panel
Also there is a tool which might help tracing down problematic hooks: Event Interceptor Panel

  • Like 2
Link to comment
Share on other sites

  • 3 weeks later...

Now solved!!!

The issue turned out to be one page field within a repeater.  I'd set 'Template of selectable page(s)' to 'blog-post' and then set 'sort=-blog_date' in the 'Custom Selector to find selectable pages' field thinking the two selectors would combine. Turns out they don't, at least not in this way.  All pages, repeaters and other admin sub pages were selectable within this field. The site has hundreds of pages, many with a large number of repeaters in so every time the page admin was loaded / saved it read all of them.

Combining the required filters with only the statement 'page-template=blog_post,sort-=blog_date' for this page field did the trick and the admin for this template (and saving pages with this template) now works really quickly.

Phew!

  • Like 3
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Similar Content

    • By Robin S
      This module lets you add some custom menu items to the main admin menu, and you can set the dropdown links dynamically in a hook if needed.
      Sidenote: the module config uses some repeatable/sortable rows for the child link settings, similar to the ProFields Table interface. The data gets saved as JSON in a hidden textarea field. Might be interesting to other module developers?
      Custom Admin Menus
      Adds up to three custom menu items with optional dropdowns to the main admin menu.
      The menu items can link to admin pages, front-end pages, or pages on external websites.
      The links can be set to open in a new browser tab, and child links in the dropdown can be given an icon.
      Requires ProcessWire v3.0.178 or newer.
      Screenshots
      Example of menu items

      Module config for the menus

      Link list shown when parent menu item is not given a URL

      Advanced
      Setting child menu items dynamically
      If needed you can set the child menu items dynamically using a hook.
      Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); if($menu_number === 1) { $colours = $event->wire()->pages->findRaw('template=colour', ['title', 'url', 'page_icon']); $children = []; foreach($colours as $colour) { // Each child item should be an array with the following keys $children[] = [ 'icon' => $colour['page_icon'], 'label' => $colour['title'], 'url' => $colour['url'], 'newtab' => false, ]; } $event->return = $children; } }); Create multiple levels of flyout menus
      It's also possible to create multiple levels of flyout submenus using a hook.

      For each level a submenu can be defined in a "children" item. Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); if($menu_number === 1) { $children = [ [ 'icon' => 'adjust', 'label' => 'One', 'url' => '/one/', 'newtab' => false, ], [ 'icon' => 'anchor', 'label' => 'Two', 'url' => '/two/', 'newtab' => false, 'children' => [ [ 'icon' => 'child', 'label' => 'Red', 'url' => '/red/', 'newtab' => false, ], [ 'icon' => 'bullhorn', 'label' => 'Green', 'url' => '/green/', 'newtab' => false, 'children' => [ [ 'icon' => 'wifi', 'label' => 'Small', 'url' => '/small/', 'newtab' => true, ], [ 'icon' => 'codepen', 'label' => 'Medium', 'url' => '/medium/', 'newtab' => false, ], [ 'icon' => 'cogs', 'label' => 'Large', 'url' => '/large/', 'newtab' => false, ], ] ], [ 'icon' => 'futbol-o', 'label' => 'Blue', 'url' => '/blue/', 'newtab' => true, ], ] ], [ 'icon' => 'hand-o-left', 'label' => 'Three', 'url' => '/three/', 'newtab' => false, ], ]; $event->return = $children; } }); Showing/hiding menus according to user role
      You can determine which menu items can be seen by a role by checking the user's role in the hook.
      For example, if a user has or lacks a role you could include different child menu items in the hook return value. Or if you want to conditionally hide a custom menu altogether you can set the return value to false. Example:
      $wire->addHookAfter('CustomAdminMenus::getMenuChildren', function(HookEvent $event) { // The menu number is the first argument $menu_number = $event->arguments(0); $user = $event->wire()->user; // For custom menu number 1... if($menu_number === 1) { // ...if user does not have some particular role... if(!$user->hasRole('foo')) { // ...do not show the menu $event->return = false; } } });  
      https://github.com/Toutouwai/CustomAdminMenus
      https://processwire.com/modules/custom-admin-menus/
    • By sambadave
      Hi there
      Short version of question
      Let's say I have a page in the admin that contains a field... Is it possible to output the content from that field on another page in the admin? Almost like a reference.
      Longer version of question (with example)
      A house builder with multiple (60+) developments. They want to be able to create notices/messages that can be added to one or many developments. Handy for things like regional covid lockdowns or temporary office closures due to bad weather.
      My approach for the admin editing options:
      Add each message to each development
      Pros: You edit the message on the development page in context
      Cons: Very time consuming and repetitive if the same message needs to be applied to 60+ developments
        Control all the messages from one admin page and say which development each message should be applied to
      Pros: Easier to add/remove messages to more than one development at a time. Control all messages from one place.
      Cons: Content is not added on development page, which is where typical admin users may expect to find it I went for option 2 due to flexibility, and created a page within the admin for global development notices. This contains a repeater with:
      Field for message to display Checkbox list of all developments. The user can select which ones to apply each message to It's working really well but the only thing is that if the user goes to a specific development in the admin, the relevant messages aren't displayed in context (as they aren't edited on that page and instead on the global development notices page)... which may cause confusion when a new staff member / content admin tries to edit the text but there is no field when they go to the development admin page where they expect to see it...
      Solution???
      I don't require the message(s) to also be editable on the development page, but I wondered if there was a nice way to show it/them somehow. I feel like I am missing something really simple as I'm sure ProcessWire will have a nice way of achieving this, or maybe there are field settings that allow this kind of thing to happen?
      Any ideas on approaches or similar experiences would be much appreciated, even if it is just a much simpler example with the content from one field being shown on another admin page to get the ball rolling.
      Thanks in advance for any advice :)
    • By humanafterall
      Hi,
      I would like to set an admin template to 'https only' as recommended in the Processwire security docs.
      However if I do this it forces this setting locally too, resulting in https://localhost requests which result in an error page.
      Is there a simple way round this? Setting https for templates in the config?
      Thanks!
    • By DanielKit
      Hi. I'm currently stuck at the login page in my project. Once I enter my admin username and my password and press login, nothing happens. The page just reloads. However, the URL changes from http://myipaddress/processwire to http://myipaddress/processwire/?login=1. I've checked all of my server settings, and to my knowledge, all seems to be fine there. I don't know where to go from here.. Thanks in advance!
    • By modifiedcontent
      Small annoyance: I get a horizontal scrollbar in UIkit admin area - or actually Admin Theme Boss based on Uikit 3. I tried to fix it with CSS, but had trouble isolating/targeting it and don't want to mess with module or core files. I think this issue has been reported before. Is there a recommended fix? 
×
×
  • Create New...