Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/c05f8b2e7d7a0574#
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,