Re: AW: db size problem (4GB monster)
Jörn Paessler <[email protected]>
| Newsgroups | gmane.comp.cms.zms.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi everybody, thank you for the hints. Finally we got the XML export reimported again. The problem was: we had to rename the "id"-attributes of ZMSTextarea objects which were parts of special objects to "id_fix" as well: Before: <ZMSCustom id_fix="e1513" meta_id="content_area"><ZMSTextarea id="text_1" id_prefix="text_">... After: <ZMSCustom id_fix="e1513" meta_id="content_area"><ZMSTextarea id_fix="text_1" id_prefix="text_">... The id-attributes of all entity-identifiers (e1234) were renamed anyway. It would make sense to add this information to this "Tipps&Tricks" section of this page: <http://www.zms-publishing.com/support/content/e732/e736/e855/e857/index_ger.html > After the reimport the size of the database is only 110 MB. Uff. Best Jörn ----------------------------------------------------------------------------------------------- beyond content GmbH Dipl.-Ing. Jörn Paessler Geschäftsführer Burgschmietstr. 10 90419 Nürnberg, Germany E-Mail: [email protected] Web: www.beyond-content.de Fon: +49 (0)911 977 98162 Fax: +49-(0)911 787 2525 Geschäftsführer: Dipl.-Ing. Jörn Paessler Sitz der Gesellschaft: Nürnberg Handelsregister: Amtsgericht Nürnberg HRB 23740 USt-IdNr.: DE247571538 Am 01.10.2008 um 18:16 schrieb Dr. Frank Hoffmann: > > Hello, > Maybe this helps reducing zodb-size: > http://www.zopelabs.com/cookbook/1054240694 > > After running the big file again this DTML hay help to reduce data > size by > removing some irrelevant attributes: > %<----------------------------------------- > <html> > <body> > <dtml-with "content"> > <dtml-call f_standard_html_request> > <dtml-let l="[this()]"> > <dtml-call "l.extend(getTreeNodes(REQUEST))"> > <dtml-in l> > <dtml-let ob=sequence-item> > <dtml-in "operator_getattr(ob,'__dict__').keys()" sort > ><dtml-let key=sequence-item > ><dtml-comment><dtml-var key><br/></dtml-comment > ><dtml-if "key in > ['zcat_data_eng > ','zcat_data_ger','oRoot','oRootNode','oParent','oCurrNode',' > bInRootTag','bInCData']"> > <dtml-call "operator_delattr(ob,key)"> > <dtml-var "ob.absolute_url()"> <dtml-var key><br/> > </dtml-if> > </dtml-let> > </dtml-in> > </dtml-let> > </dtml-in> > </dtml-let> > </dtml-with> > </body> > </html> > %<----------------------------------------- > > Good Luck > fh , moderator > > > >