Hi, I have problems with my hosting company
They send me letter about high server resourses on my gallery
Quotecpu: 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)
Quotecpu: 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)
QuoteSELECT * 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.
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?
That query is from the 'most viewed' meta album. If you have it set to be displayed on the index page disable it.
Thx, I disable it :)