|
In-Portal Issue Tracker - In-Portal CMS
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Type: | Reproducibility: | Date Submitted: | Last Update: |
| 669 | [In-Portal CMS] Optimization | task | N/A | 2010-03-27 18:01 | 2010-03-27 18:01 |
|
|
|||||
| Reporter: | alex | Platform: | |||
| Assigned To: | OS: | ||||
| Priority: | normal | OS Version: | |||
| Status: | active | Product Version: | 5.0.3-B1 | ||
| Product Build: | Resolution: | open | |||
| ETA: | none | Fixed in Version: | |||
| Reference: | http://groups.google.com/group/in-portal-dev/browse_thread/thread/c05f8b2e7d7a0574 | ||||
| Change Log Message: | |||||
| Estimate Points: | 0 | ||||
|
|
|||||
| 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 |
||||
| Relationships | |||||
| Attached Files: | |||||
|
|
|||||
| 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 | ||
| There are no notes attached to this issue. |