ResourceId field refactoring

[Alexander Obuhovich]

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.

--
Best Regards,

http://www.in-portal.org
http://www.alex-time.com

[Dmitry Andrejev]

This is an interesting idea. Do you think changing this for existing Prefixes or for new ones?

If existing - please list which one you think is need to be changed.


DA.

--

You received this message because you are subscribed to the Google Groups "In-Portal Development" group.
To post to this group, send email to in-por...@googlegroups.com.
To unsubscribe from this group, send email to in-portal-de...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/in-portal-dev?hl=en.

[Alexander Obuhovich]

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

[Dmitry A.]

Thanks Alex - this is quite useful information!

DA.

On Dec 29 2009, 11:52 am, Alexander Obuhovich <aik.b...@gmail.com>
wrote:
> *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
>

> On Mon, Dec 21, 2009 at 1:28 AM, Dmitry Andrejev <dandre...@gmail.com>wrote:
>
>
>
> > This is an interesting idea. Do you think changing this for existing
> > Prefixes or for new ones?
>
> > If existing - please list which one you think is need to be changed.
>
> > DA.
>

> > On Sat, Dec 19, 2009 at 5:58 AM, Alexander Obuhovich <aik.b...@gmail.com>wrote:
>
> >> 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.
>
> >> --
> >> Best Regards,
>
> >>http://www.in-portal.org
> >>http://www.alex-time.com
>
> >> --
> >> You received this message because you are subscribed to the Google Groups
> >> "In-Portal Development" group.
> >> To post to this group, send email to in-por...@googlegroups.com.
> >> To unsubscribe from this group, send email to

> >> in-portal-de...@googlegroups.com<in-portal-dev%2Bunsu...@googlegroups.com>

> >> .
> >> For more options, visit this group at
> >>http://groups.google.com/group/in-portal-dev?hl=en.
>
> >  --
> > You received this message because you are subscribed to the Google Groups
> > "In-Portal Development" group.
> > To post to this group, send email to in-por...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > in-portal-de...@googlegroups.com<in-portal-dev%2Bunsu...@googlegroups.com>

[Alexander Obuhovich]

Here is the task: http://tracker.in-portal.org/view.php?id=669

To unsubscribe from this group, send email to in-portal-de...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/in-portal-dev?hl=en.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com