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!

Viewing Issue Simple Details Jump to Notes ] Wiki ] View Advanced ] Issue History ] Print ]
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 Project Name In-Portal CMS
Assigned To !COMMUNITY Developer
Priority normal Resolution open Fixed in Version
Status needs feedback Product Version 5.0.1 Target Version Icebox
Time EstimateNo estimate
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
Tags No tags attached.
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0000882)
Dmitry (manager)
2009-10-12 11:32

Do we have anything done with this already or need to implement and test from scratch?
User avatar (0000993)
alex (manager)
2009-10-26 14:47

We have some ideas/code from other projects and we need to port it here.
User avatar (0000996)
Dmitry (manager)
2009-10-26 17:16

Ok, great - let's start posting -- patches / snippets of code / ideas here.

- Issue History
Date Modified Username Field Change
2009-10-26 17:16 Dmitry Note Added: 0000996
2009-10-26 17:16 Dmitry Status needs work => needs feedback
2009-10-26 17:16 Dmitry Status needs feedback => needs work
2009-10-26 17:16 Dmitry Assigned To Dmitry => !COMMUNITY
2009-10-26 14:47 alex Note Added: 0000993
2009-10-26 14:47 alex Assigned To alex => Dmitry
2009-10-12 11:32 Dmitry Note Added: 0000882
2009-10-12 11:32 Dmitry Assigned To => alex
2009-10-12 11:32 Dmitry Status active => needs feedback
2009-10-12 06:45 alex Target Version => Icebox
2009-10-12 06:44 alex New Issue

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

Powered by Mantis Bugtracker