Make coppermine a performance monster, remove all count/stat queries

[net]

Hi,

I'm trying to setup coppermine to use as little features as possible (read sql) i would like to remove all counts, statistics (queries) also order by. I've found most of them in include.inc.php however there are some queries i cannot find!

First:

Code Select Expand

    [11] => SELECT user_favpics FROM test_favpics WHERE user_id = 1 (0s)

Also there is a query (don't know which one) but it gathers all category statistics, which slows down the gallery greatly when you have many categories with alot of albums in them.

Im guessing it might be this query?

Code Select Expand

[15] => SELECT count(*) FROM test_pictures as p, test_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 140 (0s)[code]

Any help or a kick in right direction is appreciated, thanks guys.[/code]

[net]

sorry ofcourse i ment functions.inc.php