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 Advanced Details [ Jump to Notes ] [ Wiki ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Type

Reproducibility

Date Submitted

Last Update

0000669

[In-Portal CMS] Optimization

task

N/A

2010-03-27 18:01

Reporter

alex

View Status

public

Project Name

In-Portal CMS

Assigned To

Developer

Priority

normal

Resolution

open

Platform

Status

active

OS Version

ETA

none

Fixed in Version

Product Version

5.0.3-B1

Target Version

Icebox

Product Build

Time Estimate

No estimate

Summary

0000669: ResourceId field refactoring

Description

I propose to refactor implementation of ResourceId field. Now ResourceId field is unique for all database. We should add Prefix column, where ResourceId column is being used (not in main tables of course) and store ID of item instead of it's ResourceId (category item review system is using this for now using ItemId and ItemPrefix fields). This will be faster to query and use. For example we don't need additional database query to get actual item's ID by it's resource id.

Steps To Reproduce

Additional Information

Places, where ResourceId field is defined:

int_Category.ResourceId
int_Link.ResourceId
int_News.ResourceId
int_PortalGroup.ResourceId - possible, that it's not used
int_PortalUser.ResourceId
int_Posting.ResourceId - possible, that it's not used
int_Products.ResourceId
int_Topic.ResourceId

Places, where ResourceId field is used:

int_AffiliatePlansItems.ItemResourceId
int_CategoryCustomData.ResourceId
int_CategoryItems.ItemResourceId
int_Favorites.ResourceId
int_Images.ResourceId
int_ItemFiles.ResourceId
int_LinkCustomData.ResourceId
int_LinkVisits.ResourceId
int_Listings.ItemResourceId
int_NewsCustomData.ResourceId
int_PortalUserCustomData.ResourceId
int_ProductsCouponItems.ItemResourceId
int_ProductsCustomData.ResourceId
int_ProductsDiscountItems.ItemResourceId
int_RelatedSearches.ResourceId
int_SpamControl.ItemResourceId
int_TopicCustomData.ResourceId
int_AffiliatePlansItems.ItemResourceId

Issue History
Date Modified	Username	Field	Change
2010-03-27 18:01	alex	New Issue
2010-03-27 18:01	alex	Reference	=> http://groups.google.com/group/in-portal-dev/browse_thread/thread/c05f8b2e7d7a0574

Relationships [ Relation Graph ] [ Dependency Graph ]