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!

Dependency Graph

[ View Issue ] [ Relation Graph ] [ Vertical ]

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