Fixing asset table for huge site - Joomla! Forum - community, help and support
hi there,
some background - have project import huge (over 700 mb) database proprietary cms , move open source solution. i've decided use joomla after research. imported users, articles , categories additional data. except asset table.
i know - covered in docs , assetweaver , assetfix scripts, but... articles close 130k , lot of categories impossible use documented solution (manualy moving articles new categories), assetweaver took more 2 weeks , crashed @ 4gb ram usage (this on powerful machine (physical machine ibm x3650m4 care - xeon 2650 32 gb, ssd ) , script running alone - no other processes or connections). assetfix slower counts on store every article - transfers load php mysql. aside - assetfix able generate 70k asset records - incorrect ones there more categories , articles arrange.
so, after clearing - there solution this? we've severe performance hits , site slow.
some background - have project import huge (over 700 mb) database proprietary cms , move open source solution. i've decided use joomla after research. imported users, articles , categories additional data. except asset table.
i know - covered in docs , assetweaver , assetfix scripts, but... articles close 130k , lot of categories impossible use documented solution (manualy moving articles new categories), assetweaver took more 2 weeks , crashed @ 4gb ram usage (this on powerful machine (physical machine ibm x3650m4 care - xeon 2650 32 gb, ssd ) , script running alone - no other processes or connections). assetfix slower counts on store every article - transfers load php mysql. aside - assetfix able generate 70k asset records - incorrect ones there more categories , articles arrange.
so, after clearing - there solution this? we've severe performance hits , site slow.
welcome joomla forum!
the (commercial extension) acl manager has option recreate records in assets table.
http://extensions.joomla.org/extensions ... trol/17951
i don't know if uses same, or different method assetweaver , assetfix scripts you've used.
the (commercial extension) acl manager has option recreate records in assets table.
http://extensions.joomla.org/extensions ... trol/17951
i don't know if uses same, or different method assetweaver , assetfix scripts you've used.
Comments
Post a Comment