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!
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

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

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0000669 [In-Portal CMS] Optimization task N/A 2010-03-27 18:01 2010-03-27 18:01
Reporter alex View Status public  
Assigned To
Priority normal Resolution open  
Status active      
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.
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

Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

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

Powered by Mantis Bugtracker