coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: net on July 19, 2009, 03:32:30 PM

Title: Disable category statistics
Post by: net on July 19, 2009, 03:32:30 PM
Hi,

I've already disabled the album statistics, now i want to disable the category statistics. I would think they would be under the HTML template_cat_list but i can't find it within the code. Tried to search the forums, couldn't find what i was looking for. Thanks!
Title: Re: Disable category statistics
Post by: net on July 19, 2009, 03:42:58 PM
Nevermind, found the solution: http://forum.coppermine-gallery.net/index.php/topic,25375.0.html

However, i'm getting confused. By removing the statistics output on albums & categories does exactly nothing with the amount of queries generated... I'm guessing all the queries still are done, only difference is, i don't output the data. That's just stupid, i wan't to remove the entire source that generates the load, i don't want to remove something on the surface only to have the shit running in the background.

I can't find any good information how to remove the entire statistics part of albums/categories, i'm guessing there's something with the functions.inc.php? Could use some help here, thanks.
Title: Re: Disable category statistics
Post by: net on July 19, 2009, 04:15:47 PM
    [55] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (2.583s)
    [56] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES'  (1.271s)

These queries have something to do with using private albums or not? I approve everyone in all albums, is there anyway to remove the feature so that sql dosn't have to scan the entire index to see if they are allowed or not?