Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: High server resourses  (Read 3119 times)

0 Members and 1 Guest are viewing this topic.

dj_fat

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
[Solved]: High server resourses
« on: July 22, 2008, 07:40:36 pm »

Hi, I have problems with my hosting company
They send me letter about high server resourses on my gallery

Quote
cpu: 81.5% mem: 0.5% rss: 10.6M uptime: 00m 00s cpu time: 00m 00s
(exe: /usr/bin/php) (cwd: /home/xlclubru/public_html/foto)
(cmd: /usr/bin/php /home/xlclubru/public_html/foto/thumbnails.php)

Quote
cpu: 80.0% mem: 0.5% rss: 10.4M uptime: 00m 00s cpu time: 00m 00s
(exe: /usr/bin/php) (cwd: /home/xlclubru/public_html/foto)
(cmd: /usr/bin/php /home/xlclubru/public_html/foto/displayimage.php)

and this sql is slow (it's from cpmfetch for joomla site)

Quote
SELECT * FROM cpg14x_pictures WHERE approved = "S"AND hits > N   ORDER BY hits DESC, filename   LIMIT N ,N

I have more than 7000 pictures in my gallery and and use cpmfetch to show 3 random pictures on joomla site.

P.S. Sorry for bad english.
« Last Edit: July 25, 2008, 07:06:51 am by Joachim Müller »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: High server resourses
« Reply #1 on: July 23, 2008, 07:24:38 am »

Well, if that script eats up too many resources, you'll have to disable it or find another webhost who allows more resources consumption. What answer do you expect?
Logged

Nibbler

  • Guest
Re: High server resourses
« Reply #2 on: July 23, 2008, 10:37:38 am »

That query is from the 'most viewed' meta album. If you have it set to be displayed on the index page disable it.
Logged

dj_fat

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: High server resourses
« Reply #3 on: July 24, 2008, 11:44:12 pm »

Thx, I disable it  :)
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.