Announcement

  •  » Your Piwigo
  •  » Themes and plugins impact speed!

#1 2012-06-28 12:45:57

newmikey
Member
Heiloo, NL
2012-06-25
9

Themes and plugins impact speed!

My site was slow as a pig - it bothered me and to a large extent those who tried to get at my shots. Most would just not click the site a second time. All parts were affected: frontpage, albums overview, album content as well as slideshow - it was terrible.

I thought at first it was the hosting provider but I took Arvixe because it is a recommended Piwigo partner - would be a bad show if they didn't live up to things...they did.

As all piwigo noobs, I presume, I went wild with plugins at first and that's where my attention went to next. Transferred to a simple theme and removed all of the plugins, reinstalling them one by one. The "About 1 menu " plugin seems to have had a huge part in slowing down the whole site.

Even after that the slideshow stayed a bit less than optimal so I looked at some example piwigo sites' source code on Firefox (notably http://mimmosantorofotografie.piwigo.com) and found out it uses colorbox as slideshow viewer.

Closest I got was installing a plugin called "Lightbox" and the impact was dramatic! Much, much improved - I am truly relieved, had already started looking at alternatives for piwigo but found none as richly featured.

Oh, BTW, I of course started out by cleaning up the database and regenerating all thumbnails but that seemed to have little impact on the sluggishness of the gallery.

If you'd want to comment or tip me off to more tricks, please have a look at http://www.mike.bing-photography.com and let me know how the site is performing ion your side. I'd be ever so thankful.

Last edited by newmikey (2012-06-28 12:46:42)

Offline

 

#2 2012-06-28 13:01:40

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13195

Re: Themes and plugins impact speed!

Hi newmikey,

I you want to be sure that Piwigo is getting slow due to a plugin, in the local configuration (use LocalFiles Editor, I swear it doesn't impact speed), add:

Code:

<?php
$conf['show_gt'] = true; // gt = generation time
?>

and look at what Piwigo says in the footer of your pages when the plugins are active or not.

If the pages are slower than 150ms to generate then you may have a problem with your host.

Offline

 

#3 2012-06-28 13:27:16

flop25
Piwigo Team
2006-07-06
6937

Re: Themes and plugins impact speed!

I have a wordpress with many plugins and a piwigo with a dozen of plugins, and piwigo is much much faster than wordpress


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#4 2012-06-28 13:32:27

newmikey
Member
Heiloo, NL
2012-06-25
9

Re: Themes and plugins impact speed!

@plg

On the main page the result is: "Page generated in 2.450 s (13 SQL queries in 1.690 s)"
On the gallery overview (albums view): "Page generated in 2.321 s (15 SQL queries in 1.788 s)"
Opening one album to show the individual thumbnails: "Page generated in 2.561 s (18 SQL queries in 1.914 s)"

So it does seem slow?

Offline

 

#5 2012-06-28 13:36:06

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13195

Re: Themes and plugins impact speed!

newmikey wrote:

So it does seem slow?

awfully slow

just look at the times we have on http://piwigo.us/beta/24/ :

* Page generated in 0.085 s (13 SQL queries in 0.038 s) gallery home page
* Page generated in 0.039 s (14 SQL queries in 0.002 s) thumbnails page
* Page generated in 0.039 s (14 SQL queries in 0.002 s) admin page

Offline

 

#6 2012-06-28 15:26:05

newmikey
Member
Heiloo, NL
2012-06-25
9

Re: Themes and plugins impact speed!

I'm getting there - could be something specific to my install (2.3.4). I just installed a fresh 2.4 in a subdirectory and copied the images across - as well as putting in the timing code suggested earlier.

Getting better speeds by far but lost a great many plugins ;-( that aren't yet compatible with 2.4

Thumbnail page inside album: Page generated in 0.066 s (15 SQL queries in 0.004 s)
Gallery page: Page generated in 0.072 s (21 SQL queries in 0.006 s)

Offline

 

#7 2012-06-28 16:16:00

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13195

Re: Themes and plugins impact speed!

newmikey wrote:

Thumbnail page inside album: Page generated in 0.066 s (15 SQL queries in 0.004 s)
Gallery page: Page generated in 0.072 s (21 SQL queries in 0.006 s)

OK, that's very good times.

When you will activate plugins one by one, see which one slow everything done (most of the time, it is Whois Online as far as my experience can tell me)

Offline

 

#8 2012-06-28 20:39:36

grum
Piwigo Team
Nantes
2007-09-10
1371

Re: Themes and plugins impact speed!

more interesting than activte plugin one by one, you can also set this option:

Code:

$conf['show_queries'] = true;

this will show you the detail of each SQL request, which time it take, like that:

Code:

SELECT id, name
  FROM piwigo_languages
  ORDER BY name ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.021 s)
(total time      : 0.151 s)
(num rows        : 47 )

[26] 
SELECT id, name
            FROM piwigo_categories
            WHERE id IN(9);
(this query time : 0.000 s)
(total SQL time  : 0.022 s)
(total time      : 0.151 s)
(num rows        : 1 )

you'll easily see which request is slow.


My pictures with Piwigo, of course !
[ www.grum.fr ] [ photos.grum.fr ]

Offline

 

#9 2012-06-28 21:01:49

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13195

Re: Themes and plugins impact speed!

Page generated in 2.321 s (15 SQL queries in 1.788 s)

OK SQL is slow but it's still 533 ms outside SQL = very slow.

Offline

 

#10 2012-07-02 11:44:04

newmikey
Member
Heiloo, NL
2012-06-25
9

Re: Themes and plugins impact speed!

Guys, we can mark this one solved. Haven't gotten to the bottom of this but it must have been an anomaly in the DB of the 2.3.5 install. Did a clean install of 2.4 and the times now seem up there with the best of 'm!

Many thanks for the help!

PS: also integrated a page-filling slideshow as frontpage ( with the additional pages plugin set to full HTML ) with an opensource script found here: www.buildinternet.com/project/supersized

Offline

 
  •  » Your Piwigo
  •  » Themes and plugins impact speed!

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact