Cache (no need, when memcache is used) - NO, I would KEEP this one since it can be used for all type of System Caching when no Memcache available... we do need this type of table available. At some point, I was thing about having it all saved in PHP files or something, but now imagine we have 2+ Web servers that need to share the same configuration (ie. VIC project). In this case DB is by far the most efficient after the Memcache.
IdGenerator (table, that keeps track of ResourceIds generated, get rid of it in future) - YES, I am sure we can use one of existing table (ie. Cache for now), and get rid of this at all later on?
PhraseCache (merge with CachedUrls somehow) - YES, we can quickly get rid of this one
PopupSizes (store in PortalUser.PopupSizes field/PersistentSessionData table as serialized array, we can have key, like md5(template_path) and popup size)
- YES, we can quickly get rid of this one
Counters (we only have 3 counters and can easily transfer them to memcache) - YES, we can quickly get rid of this oneStatItem (delete) - YES, we can quickly get rid of this one
In-Portal tables that can be moved into separate modules========================================================
BanRules============ LOGS ====================
SessionLogsChangeLogsCurlLogSlowSqlCaptureStatisticsCapture
======= CUSTOM FIELDS =========================CustomFieldCategoryCustomDataPortalUserCustomData============ MAILING LISTS ====================EmailQueueEmailLog - I would move to LOGS module aboveMailingLists=========== CATALOG ITEMS =====================CategoryItemsFavoritesImages - I would possibly move to CORE since this can be used by ANY of Categories and we don't have a solid replacement for it yet.
ImportCacheImportScriptsItemFilesItemFiltersItemRatingItemReviewItemTypesSearchLogRelatedSearchesCountCacheSpamReportsSpamControlRelationship
============ SUBMISSION FORMS ====================
DraftsFormFieldsFormsFormSubmissionsSubmissionLog
============ MULTI-SITE SUPPORT ====================SiteDomains============ NOT SURE ABOUT THIS MODULE NAME ====================
ThesaurusSpellingDictionaryStopWordsOn Mon, Feb 21, 2011 at 9:35 PM, Dmitry A. <dand...@gmail.com> wrote:
Quick update here.There is a separate discussion ( https://groups.google.com/d/topic/in-portal-bugs/uwfyKB34V7s/discussion ) / task ( http://tracker.in-portal.org/view.php?id=1006 ) where we are going to delete the following tables:1. Stylesheets - no longer in use, must be deleted - DELETE
2. StylesheetSelectors - no longer in use, must be deleted - DELETE
3. SysCache - I don't know what this is - DELETE
4. TagAttributes - no longer in use, must be deleted - DELETE
5. TagLibrary - no longer in use, must be deleted - DELETEAlex what do you think on the main list so far?DA