Hi, any solution to this? K2 generates a lot of cache files and they end even producing ocasional out-of-memory errors in the cache management...
PHP is a acripting language, so my guess is that DB accesses are treated dynamically, and therefore they choose the best index that already exists, but AFAIK, mysql doesn't create 'temporary indexes'...
I've had a look at K2's DB performance and found that there are some optimizations that could be made:Some indexes for better/faster access:ALTER TABLE `jos_k2_comments` ADD INDEX `pub_id` (`published`, `itemID`); ALTER TABLE `jos_k2_tags`...
I would like to know about thus too. Is there any solution to simply present a list of categories? I think maybe this could be done including the module k2_tools as content, but I would prefer a simpler solution... Simon Wells (K2 Support)...
More