Please login or register.
Login with username, password and session length
December 13, 2018, 04:42:10 AM
News:
collapse

* User Info

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

* Recent Posts

Pluign and module by whazzup
[June 08, 2018, 11:57:13 PM]


Version 4.4.1 released by whazzup
[May 31, 2018, 04:31:16 PM]


search.html.php refer to rsgsearch.css with a wrong path by whazzup
[January 13, 2018, 08:12:04 PM]


Slow Gallery with many Photos by whazzup
[September 22, 2017, 09:22:33 AM]


Batch Upload via frontend by whazzup
[September 11, 2017, 10:20:50 PM]


Version 4.3.1 released by whazzup
[August 07, 2017, 10:34:02 PM]


File upload limit is 2MB by whazzup
[July 31, 2017, 10:09:21 PM]


Fixed: Users can see other users galleries name when they try to add photos. by whazzup
[July 23, 2017, 03:56:35 PM]

Pages: [1] 2   Go Down

Author Topic: Slow Gallery with many Photos  (Read 10693 times)

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Slow Gallery with many Photos
« on: June 12, 2007, 06:53:41 PM »
Hi everyone,

I've installed the RSGallery2 on a big CommunityPage.
We have over 7000 Pictures in about 120 Galleries.

I've noticed that it takes a lot of time (about 8 sec.) when i click on the Main-Gallery-Overview.
When i open a single Gallery the Thumbnails appear directly and the Gallerysystem is very fast. But not the Main-Page.

To reduce the time to about 5 sec i've disabled the random thumbnail for every Gallery in the Overview. But i don't think that this is a very good solution. But commenting out the MySQL-Query for the random thumbnail gave me 3 secs.

Is there any better solution?

Greetings from Germany

P.S.: Sorry for my bad english  :(

Offline Daniel Tulp

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.870
  • Search search search before posting please
    • design.danieltulp.nl

Re: Slow Gallery with many Photos
« Reply #1 on: June 13, 2007, 12:02:14 AM »
your english is quite ok

how many galleries do you have on the main page?
do you use the limitbox?
RSgallery2 developement team
RSgallery2 modules:
design.danieltulp.nl

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #2 on: June 13, 2007, 05:54:35 AM »
Yes I tried using the Limitbox with 15 Gallerys, but its still the same.
I think the MySQL query for searching the rights Pictures for the right gallery from more than 7000 Pix / MySQLentries is what makes it so slow

But i like the RSGallery and its watermark-feature and i don't want to use any other gallery :)

Offline Jonah

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.412

Re: Slow Gallery with many Photos
« Reply #3 on: June 13, 2007, 06:52:13 PM »
If you usually have more than one concurrent visitor you should not be using the watermark feature at this time.  Wait for it to be rewritten.

Can you either post your website or PM it to Daniel or I?  Can you enable slow query logging to see if queries are the issue?
Due to time constraints, I have taken a step back from RSGallery2.  In the event of an emergency, you will need to PM me.

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #4 on: June 13, 2007, 10:31:31 PM »
Just feel free to visit my Website:
www.himmerich-fanpage.de, you can find die Picutre here: Party Pics

Offline Ronald Smit

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.214
    • RSDevelopment

Re: Slow Gallery with many Photos
« Reply #5 on: June 14, 2007, 07:56:24 AM »
I don't see any thumbnails in the main gallery page.
Did you disable them completely?

You could always set a fixed thumbnail for each gallery.
This is configurable in the Manage Galleries area in the backend.

Have you tried that already?

Ronald Smit
RSGallery2 Developer
FAQ|Known issues

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #6 on: June 14, 2007, 10:58:17 AM »
Yes i disabled thumbnails completely.

As I said bevore: With Thumbnails it takes about 8 Sec. to open the Overview
Without (as it is now) it takes about 5 Sec. and for me its still too long :(

Offline Jonah

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.412

Re: Slow Gallery with many Photos
« Reply #7 on: June 14, 2007, 08:56:26 PM »
Turn them on for a day or so if you don't mind.  I would like to try a few things.
Due to time constraints, I have taken a step back from RSGallery2.  In the event of an emergency, you will need to PM me.

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #8 on: June 15, 2007, 04:49:08 AM »
Ok, i turned on the Randomthumbnails :)

Offline Ronald Smit

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.214
    • RSDevelopment

Re: Slow Gallery with many Photos
« Reply #9 on: June 15, 2007, 09:11:11 AM »
Oliver,

The point that I was trying to make, there are two options of displaying a thumbnail.
Default setting is a random thumbnail. This sets of a query every time the main page is requested.
You can also choose a dedicated thumbnail for every gallery. This means you select the image in the backend, and it will always show the same thumbnail. Use the Gallery thumbnail dropdown in the Edit gallery screen. This way, that image ID is part of the gallery object and the other query isn't used. Try setting that and see if that reduces time to load.

Ronald
Ronald Smit
RSGallery2 Developer
FAQ|Known issues

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #10 on: June 15, 2007, 11:20:02 AM »
Okay, I tried setting it to a dedicated Thumbnail (what takes quite a long clicking-time for 122 Galleries), but i did not recude the time. (Don't wonder if you see a random Thumbnail i set it back to randomthumbnail after trying...)

See: I've i disable the complete thumbnail-thing it takes still about 5 sec. to load the page. So I have to search for the mistake not in the thumbnails but in the code which creates the Maingallery-page.
I think the MySQL DB has to search in over 7000 entries, which file belongs to the right Gallery. I think that is was takes qite a long time.

Has anybody else so many Pictures with RSGallery? Maybe someone could tell his expierences

Offline Jonah

  • Retired from Dev Team
  • Hero Member
  • ****
  • Posts: 1.412

Re: Slow Gallery with many Photos
« Reply #11 on: June 17, 2007, 12:11:49 AM »
Thanks for helping us troubleshoot this issue Oliver.  I do have a gallery with aprox 2500 pictures and it loads in less than 1.5 seconds.

We're going to build a sample gallery with 50000 images or so and do some speed analysis on it to see what we can find.  It will take a few weeks.
Due to time constraints, I have taken a step back from RSGallery2.  In the event of an emergency, you will need to PM me.

Offline Hans

  • Jr. Member
  • **
  • Posts: 66
    • Kleuterdigitaal

Re: Slow Gallery with many Photos
« Reply #12 on: June 17, 2007, 03:25:09 PM »
Hello Guys

I got a site with +/- 5000 images 5 main galleries and +/- 450 subgalleries, the link to the main gallery takes about 8 sec. like describe earlier. Just to inform you. Subgalleries opens in +/- 3 sec.

Regards
Hans
Hans

Open source Matters

Offline Oliver Rick

  • Newbie
  • *
  • Posts: 7

Re: Slow Gallery with many Photos
« Reply #13 on: June 17, 2007, 10:40:54 PM »
Puh.... Thanks for your post, i thought i am the only one with this problem :)

Offline hedkandi1

  • Newbie
  • *
  • Posts: 16

Re: Slow Gallery with many Photos
« Reply #14 on: May 07, 2013, 07:10:16 PM »
Has there been any changes made in this topic?
I am having the same problem, even loggin in will take over 15 sec.
Pages: [1] 2   Go Up