Opening Admin Album takes 40 secs to open a 6 Image Album

darkufo

Hi,

I've got a very powerful server, 8 Core, with 8GB of RAM and 1GB of that for PHP.

The Gallery itself loads very quickly.

http://spoilertv.co.uk/images/

However, if I click on the Admin Toolbox, and select Edit Album it takes 40+ seconds to load the Edit Album screen.

I've tested this on a very small subalbum here

http://spoilertv.co.uk/images/index.php?album=episodes

It has 1 sub-album which currently has just 6 images.

Surely something is going wrong here?

Here is a screenshot of my Version/Memory/Sql etc

http://i52.tinypic.com/erls9v.png

Any helps/advice?

NOTE: I gone through the Docs here but could not see anything that would affect the admin being so so slow.

I have 6 Plugins

hitcounter v1.4.1
security-logger v1.4.1
zenFBcommon v1.4.0.2 [6701]
zenphoto_news v1.4.1
zenphoto_sendmail v1.4.1
zenphoto_seo v1.4.1

And these filters

admin_allow_access
1: security-logger.php => security_logger_adminGate
admin_log_actions
1: security-logger.php => security_logger_log_action
admin_login_attempt
1: security-logger.php => security_logger_adminLoginLogger
admin_managed_albums_access
1: security-logger.php => security_logger_adminAlbumGate
admin_overview
0: zenphoto_news.php => printNews
admin_XSRF_access
1: security-logger.php => security_logger_admin_XSRF_access
federated_login_attempt
1: security-logger.php => security_logger_federatedLoginLogger
guest_login_attempt
1: security-logger.php => security_logger_guestLoginLogger
load_theme_script
1: hitcounter.php => hitcounter_load_script
log_setup
1: security-logger.php => security_logger_log_setup
save_user
1: security-logger.php => security_logger_UserSave
sendmail
5: zenphoto_sendmail.php => zenphoto_sendmail
seoFriendly
5: zenphoto_seo.php => filterAccentedCharacters
seoFriendly_js
5: zenphoto_seo.php => filterAccentedCharacters_js
theme_body_open
1: zenFBcommon.php => zenFBcommonJS
theme_head
1: zenFBcommon.php => zenFBOpenGraphJS

The Overall Gallery has these stats

65825 Images
5739 Albums

acrylian

Honestly I have no idea and never seen that or noticed that access via the toolbox is slower. Hopefully my college has any idea.

Note if you really use that Zenphoto version that is not secure and you should at least upgrade to 1.4.1.6 (unless you did the fix manually)

darkufo

Thanks, yes I agree

I'm running Zenphoto version 1.4.1.5 [8326] (Official Build)

I always wait a few weeks before upgrading to the latest version.

My "gut" feel is that it has something to do with "Tags"

When I eventually load the Edit Album. I notice the tag list shows tags from outside this Album. This leads me to suspect that it has to collect all the tags from all images first?

Is there a way to disable Tags totally. We don't use them at all and they are hidden in the theme. Basically can we stop Zen even trying to look for them?

acrylian

Regarding release version, I hope you noticed the severe security issue with 1.4.1.5. If not head over to the news section.

The edit pages of any item features actually a list of all tags so you can easily assign them via the checkbox lists. Of course if you have lots of tags that might take some time.

The only way to disable tags is to delete them all I fear.

What often may slow down is also loading of the TinyMCE editor especially if fully featured.

darkufo

Thanks,

I've just upgraded to Zenphoto version 1.4.2.1 [9138] (Official Build)

Where is the TInyMCE Editor? I don't think I use that. How can I check?

I don't have tags but they seem to appear automatically.

acrylian

That is the editor that is loaded by default actually to edit descriptions, page or article content.
http://www.zenphoto.org/screenshots/zenphoto-1.4.2-admin/album-edit.jpg.php
It is an plugin though so you can disable it.

darkufo

Ah yes, that was already removed.

Upgrading to the latest version has brought the load time down to 20 seconds it still seems like that is way too long for an album with 6 images.

The album is set to display as single image as the thumbnail as opposed to Random etc.

I still could not find out how to stop the tags being generated?

acrylian

Tags generated? Then you get them probably via metadata. See Options > Image > metadata and disable all the fields being imported.

darkufo

Thanks, disabled all fields but still around 20 secs.

So I guess it was not that

sbillard

While it may be the tags, loading them should not be much overhead. Even with a large table all that is needed is the list of names for the display and the list that are checked for an album for for which ones to show as checked. Both are pretty simple SQL queries, so if it is the tags, then the SQL server you are using may be slow in response.

darkufo

Hi Sbillard.

I really don't think it's our SQL Server. Everything else on the server is lightening fast. The actual Gallery is very quick as you can see, as is our Forum.

The only thing that is slow is the Edit Albums. All other Admin functions are very quick.

I really don't understand what the system is doing for those 20 seconds on an album with just 6 images?

All the images are cached so I'm out of ideas what could be taking so long.

Are there any debug lines I could add so that I can see the queries that are being generated?

sbillard

Unfortunately we have no timing insertions for the back-end. Normally we concentrate on the front end for that. All the queries do go through the `query` function in functions-db-MySQL.php, so you could intrument that with calls on `debugLog()`.

darkufo

Ok thanks. I'll give that a try later.

If you can think of anything else that might be causing the massive slowness I'd be very grateful.

I assume we don't need to re-index the SQL tables after an upgraded etc?

I'm just stumped.

darkufo

Could it be the generation of the full album list for the "Move" feature

Screenshot
http://i54.tinypic.com/9rndvq.png

We have a lot of albums.

Could this be the reason?

sbillard

Does the upload tab take the same time to load?

Regards reindexing, I do not see what an upgrade would do to invalidate the index, but give it a try, can't hurt.

darkufo

Yes, the Upload tab takes 18-19 seconds. So I guess that's it.

Any workarounds?

We don't actually need the move function on the albums. Can we disable it?

sbillard

There is no easy way to disable the the utility that would actually stop the load of the list. There is a function `genAlbumUploadList()` which is called to generate the list. You could find where it is used for the album page and remove it. (I believe that the array it populates is initialized to empty, so the result will be an empty list of places to move, etc. That should work.)

darkufo

That's awesome. I'll track it down.

Thank you for your help.

darkufo

Wow, that worked a treat

Edit now loads in less than a second

iacchi

Hi, I have your same problem darkufo. Can you tell me exactly what and where you modified so I can do the same? Thanks!