Print

[dj_fat]

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

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)

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)

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.

[Joachim Müller]

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?

[Nibbler]

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

[dj_fat]

Thx, I disable it