forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: dj_fat on July 22, 2008, 07:40:36 pm

Title: [Solved]: High server resourses
Post by: dj_fat 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.

Title: Re: High server resourses
Post by: Joachim Müller 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?

Title: Re: High server resourses
Post by: Nibbler 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.

Title: Re: High server resourses
Post by: dj_fat on July 24, 2008, 11:44:12 pm

Thx, I disable it  :)