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 ]

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 Estimate

No 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.

Reference

Change Log Message

Estimate Points

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0000882) Dmitry (manager) 2009-10-12 11:32	Do we have anything done with this already or need to implement and test from scratch?

(0000993) alex (manager) 2009-10-26 14:47	We have some ideas/code from other projects and we need to port it here.

(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