In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Relationship Graph View Issue ] Dependency Graph ]
related to child of duplicate of

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0000377 [In-Portal CMS] Optimization task always 2009-10-12 06:44 2009-10-26 17:16
Reporter alex View Status public  
Assigned To !COMMUNITY
Priority normal Resolution open  
Status needs feedback      
Summary 0000377: Decrement database query count on category item lists, when mod-rewrite is used
Description Decrement database query count on category item lists, when mod-rewrite is used. Currently for each item in list additional database query is made to receive it's Filename by given ID. Actually we already have Filename field content, when displaying items. We could improve kCatDBTagProcessor::ItemLink tag to pass additional parameter to mod-rewrite in form "<prefix>_filename" and then it will be used for link building. As for case, when mod-rewrite is not used, then we should remove all url parameters in form "<prefix>_filename" from links, that are built.

Without such optimization we have total page database query count get incremented by item count displayed on page, that required nice mod-rewrite url to their detail page.

Something like that could be applied to categories too (c_CategoryLink tag).
Additional Information

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker