How to add a user to the ignore list?
AW: db size problem (4GB monster)
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Content Management System > AW: db size problem (4GB monster) 1 October 2008 20:39:11

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

AW: db size problem (4GB monster)

Dr. Frank Hoffmann 1 October 2008 20:39:11
 Hello,
Maybe this helps reducing zodb-size:
http://www.zopelabs­.com/cookbook/105424­0694 [http://www.zopelabs­.com/cookbook/105424­0694]

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_req­uest>
<dtml-let l="[this()]">
<dtml-call "l.extend(getTreeNo­des(REQUEST))">
<dtml-in l>
<dtml-let ob=sequence-item>
<dtml-in "operator_getattr(o­b,'__dict__').keys()­" sort
<dtml-let key=sequence-item
<dtml-comment><dtm­l-var key><br/></dtml-com­ment
<dtml-if "key in
['zcat_data_eng','zcat_data_ger','oRoot','oRootNode','oParent','oCurrNode','
bInRootTag','bInCData']">
<dtml-call "operator_delattr(o­b,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


__._,_.___ Messages in this topic
[http://groups.yahoo­.com/group/zms-devel­opers/message/3224;_­ylc=X3oDMTM0ZmgxMzM1­BF9TAzk3MzU5NzE0BGdy­cElkAzg0NzA4MjEEZ3Jw­c3BJZAMxNzA3MjgxOTQy­BG1zZ0lkAzMyMjgEc2Vj­A2Z0cgRzbGsDdnRwYwRz­dGltZQMxMjIyODc3Nzk4­BHRwY0lkAzMyMjQ-]
(5) Reply (via web post)
[http://groups.yahoo­.com/group/zms-devel­opers/post;_ylc=X3oD­MTJwZWNjcGs4BF9TAzk3­MzU5NzE0BGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBG1zZ0lk­AzMyMjgEc2VjA2Z0cgRz­bGsDcnBseQRzdGltZQMx­MjIyODc3Nzk4?act=rep­ly&messageNum=3228]
| Start a new topic
[http://groups.yahoo­.com/group/zms-devel­opers/post;_ylc=X3oD­MTJlMHAzNHNxBF9TAzk3­MzU5NzE0BGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBHNlYwNm­dHIEc2xrA250cGMEc3Rp­bWUDMTIyMjg3Nzc5OA--­]
Messages [http://groups.yahoo­.com/group/zms-devel­opers/messages;_ylc=­X3oDMTJlNWlxOXA1BF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA21zZ3ME­c3RpbWUDMTIyMjg3Nzc5­OA--]
| Files [http://groups.yahoo­.com/group/zms-devel­opers/files;_ylc=X3o­DMTJmNDU3dWt0BF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA2ZpbGVzBHN­0aW1lAzEyMjI4Nzc3OTg­-]
| Photos [http://groups.yahoo­.com/group/zms-devel­opers/photos;_ylc=X3­oDMTJlY2J1dW1pBF9TAz­k3MzU5NzE0BGdycElkAz­g0NzA4MjEEZ3Jwc3BJZA­MxNzA3MjgxOTQyBHNlYw­NmdHIEc2xrA3Bob3QEc3­RpbWUDMTIyMjg3Nzc5OA­--]
| Links [http://groups.yahoo­.com/group/zms-devel­opers/links;_ylc=X3o­DMTJmczhyamJ2BF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA2xpbmtzBHN­0aW1lAzEyMjI4Nzc3OTg­-]
| Database [http://groups.yahoo­.com/group/zms-devel­opers/database;_ylc=­X3oDMTJjbXZuMGc2BF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA2RiBHN0­aW1lAzEyMjI4Nzc3OTg-­]
| Polls [http://groups.yahoo­.com/group/zms-devel­opers/polls;_ylc=X3o­DMTJmYmtxbWx0BF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA3BvbGxzBHN­0aW1lAzEyMjI4Nzc3OTg­-]
| Members [http://groups.yahoo­.com/group/zms-devel­opers/members;_ylc=X­3oDMTJlamltaDd2BF9TA­zk3MzU5NzE0BGdycElkA­zg0NzA4MjEEZ3Jwc3BJZ­AMxNzA3MjgxOTQyBHNlY­wNmdHIEc2xrA21icnMEc­3RpbWUDMTIyMjg3Nzc5O­A--]
| Calendar [http://groups.yahoo­.com/group/zms-devel­opers/calendar;_ylc=­X3oDMTJkZTk0bWhpBF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA2NhbARz­dGltZQMxMjIyODc3Nzk4­]
Yahoo! Groups [http://groups.yahoo­.com/;_ylc=X3oDMTJkc­DBvM2ZhBF9TAzk3MzU5N­zE0BGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwNmdHIEc­2xrA2dmcARzdGltZQMxM­jIyODc3Nzk4]
Change settings via the Web [http://groups.yahoo­.com/group/zms-devel­opers/join;_ylc=X3oD­MTJmZzN2aGdvBF9TAzk3­MzU5NzE0BGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBHNlYwNm­dHIEc2xrA3N0bmdzBHN0­aW1lAzEyMjI4Nzc3OTg-­]
(Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest [mailto:zms-developers-digest@yahoogroups.com?subject=Email Delivery: Digest]
| Switch format to Traditional [mailto:zms-developers-traditional@yahoogroups.com?subject=Change Delivery Format: Traditional]
Visit Your Group
[http://groups.yahoo­.com/group/zms-devel­opers;_ylc=X3oDMTJkN­24zbHBqBF9TAzk3MzU5N­zE0BGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwNmdHIEc­2xrA2hwZgRzdGltZQMxM­jIyODc3Nzk4]
| Yahoo! Groups Terms of Use [http://docs.yahoo.c­om/info/terms/] |
Unsubscribe
[mailto:zms-developers-unsubscribe@yahoogroups.com?subject=] Visit
Your Group
[http://groups.yahoo­.com/group/zms-devel­opers;_ylc=X3oDMTJlM­HM3bmN0BF9TAzk3MzU5N­zE0BGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwN2dGwEc­2xrA3ZnaHAEc3RpbWUDM­TIyMjg3Nzc5OA--]Yaho­o!
Finance

It's Now Personal [http://us.ard.yahoo­.com/SIG=13oqb965t/M­=493064.12016257.124­45664.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288499­9/L=/B=CAyCD0LaX.s-/­J=1222877799158035/A­=4507179/R=0/SIG=12d­e4rskk/*http://us.rd­.yahoo.com/evt=50284­/*http://finance.yah­oo.com/personal-fina­nce]

Guides, news,

advice & more.

New business?

Get new customers. [http://us.ard.yahoo­.com/SIG=13onhl7mm/M­=493064.12016308.124­45700.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288499­9/L=/B=CQyCD0LaX.s-/­J=1222877799158035/A­=3848640/R=0/SIG=131­an6mds/*http://searc­hmarketing.yahoo.com­/arp/srchv2.php?o=US­2002&cmp=Yahoo&ctv=G­roups1&s=Y&s2=&s3=&b­=50]

List your web site

in Yahoo! Search.

Find Balance

on Yahoo! Groups [http://us.ard.yahoo­.com/SIG=13obfbnln/M­=493064.12016238.128­23558.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288499­9/L=/B=CgyCD0LaX.s-/­J=1222877799158035/A­=5286668/R=0/SIG=11i­n3uvr5/*http://new.g­roups.yahoo.com/plan­forabalancedlife]

manage nutrition,

activity & well-being.

.[IMAGE]
__,_._,___

Add comment
JЖrn Paessler 1 October 2008 20:39:11 permanent link ]
 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_ar­ea"><ZMSTextarea
id="text_1" id_prefix="text_">.­..After: <ZMSCustom
id_fix="e1513" meta_id="content_ar­ea"><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-publ­ishing.com/support/c­ontent/e732/e736/e85­5/e857/index_ger.htm­l [http://www.zms-publ­ishing.com/support/c­ontent/e732/e736/e85­5/e857/index_ger.htm­l]>
After the reimport the size of the database is only 110 MB. Uff.
BestJЖrn

-------------------­--------------------­--------------------­--------------------­----------------beyo­nd
content GmbHDipl.-Ing. JЖrn PaesslerGeschДftsfЭ­hrerBurgschmietstr. 1090419
NЭrnberg, GermanyE-Mail: joern.paessler@beyo­nd-content.de [mailto:joern.paessler@beyond-content.de]Web:
www.beyond-content.­de [http://www.beyond-c­ontent.de]Fon: +49 (0)911
977 98162Fax: +49-(0)911 787 2525GeschДftsfЭhrer­: Dipl.-Ing. JЖrn
PaesslerSitz der Gesellschaft: NЭrnbergHandelsregi­ster: Amtsgericht
NЭrnberg HRB 23740USt-IdNr.: DE247571538
Am 01.10.2008 um 18:16 schrieb Dr. Frank Hoffmann:


Hello,
Maybe this helps reducing zodb-size:
http://www.zopelabs­ [http://www.zopelabs].com/cookbook/10542­40694

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_req­uest>
<dtml-let l="[this()]">
<dtml-call "l.extend(getTreeNo­des(REQUEST))">
<dtml-in l>
<dtml-let ob=sequence-item>
<dtml-in "operator_getattr(o­b,'__dict__').keys()­" sort
<dtml-let key=sequence-item
<dtml-comment><dtm­l-var key><br/></dtml-com­ment
<dtml-if "key in
['zcat_data_eng','zcat_data_ger','oRoot','oRootNode','oParent','oCurrNode','
bInRootTag','bInCData']">
<dtml-call "operator_delattr(o­b,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



__._,_.___ Messages in this topic
[http://groups.yahoo­.com/group/zms-devel­opers/message/3224;_­ylc=X3oDMTM0M2Fib3Fn­BF9TAzk3MzU5NzE0BGdy­cElkAzg0NzA4MjEEZ3Jw­c3BJZAMxNzA3MjgxOTQy­BG1zZ0lkAzMyMjkEc2Vj­A2Z0cgRzbGsDdnRwYwRz­dGltZQMxMjIyODc5MTU4­BHRwY0lkAzMyMjQ-]
(6) Reply (via web post)
[http://groups.yahoo­.com/group/zms-devel­opers/post;_ylc=X3oD­MTJwdjUyYmI0BF9TAzk3­MzU5NzE0BGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBG1zZ0lk­AzMyMjkEc2VjA2Z0cgRz­bGsDcnBseQRzdGltZQMx­MjIyODc5MTU4?act=rep­ly&messageNum=3229]
| Start a new topic
[http://groups.yahoo­.com/group/zms-devel­opers/post;_ylc=X3oD­MTJlaGZ0YzhpBF9TAzk3­MzU5NzE0BGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBHNlYwNm­dHIEc2xrA250cGMEc3Rp­bWUDMTIyMjg3OTE1OA--­]
Messages [http://groups.yahoo­.com/group/zms-devel­opers/messages;_ylc=­X3oDMTJlNHNlMGNuBF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA21zZ3ME­c3RpbWUDMTIyMjg3OTE1­OA--]
| Files [http://groups.yahoo­.com/group/zms-devel­opers/files;_ylc=X3o­DMTJma2o2MnNyBF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA2ZpbGVzBHN­0aW1lAzEyMjI4NzkxNTg­-]
| Photos [http://groups.yahoo­.com/group/zms-devel­opers/photos;_ylc=X3­oDMTJlYXVjdW9mBF9TAz­k3MzU5NzE0BGdycElkAz­g0NzA4MjEEZ3Jwc3BJZA­MxNzA3MjgxOTQyBHNlYw­NmdHIEc2xrA3Bob3QEc3­RpbWUDMTIyMjg3OTE1OA­--]
| Links [http://groups.yahoo­.com/group/zms-devel­opers/links;_ylc=X3o­DMTJmb2ZlaXZjBF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA2xpbmtzBHN­0aW1lAzEyMjI4NzkxNTg­-]
| Database [http://groups.yahoo­.com/group/zms-devel­opers/database;_ylc=­X3oDMTJjaXFyam51BF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA2RiBHN0­aW1lAzEyMjI4NzkxNTg-­]
| Polls [http://groups.yahoo­.com/group/zms-devel­opers/polls;_ylc=X3o­DMTJmNjIzNDQzBF9TAzk­3MzU5NzE0BGdycElkAzg­0NzA4MjEEZ3Jwc3BJZAM­xNzA3MjgxOTQyBHNlYwN­mdHIEc2xrA3BvbGxzBHN­0aW1lAzEyMjI4NzkxNTg­-]
| Members [http://groups.yahoo­.com/group/zms-devel­opers/members;_ylc=X­3oDMTJldGlqMDhpBF9TA­zk3MzU5NzE0BGdycElkA­zg0NzA4MjEEZ3Jwc3BJZ­AMxNzA3MjgxOTQyBHNlY­wNmdHIEc2xrA21icnMEc­3RpbWUDMTIyMjg3OTE1O­A--]
| Calendar [http://groups.yahoo­.com/group/zms-devel­opers/calendar;_ylc=­X3oDMTJkNDhrYWdhBF9T­Azk3MzU5NzE0BGdycElk­Azg0NzA4MjEEZ3Jwc3BJ­ZAMxNzA3MjgxOTQyBHNl­YwNmdHIEc2xrA2NhbARz­dGltZQMxMjIyODc5MTU4­]MARKETPLACE
What's Your Credit Score? View yours online and instantly for $0. [http://us.ard.yahoo­.com/SIG=13rm368hl/M­=690207.12942768.132­30439.10835568/D=gro­ups/S=1707281942:MKP­1/Y=YAHOO/EXP=122288­6358/L=/B=YypMBELaX.­c-/J=122287915850599­0/A=5506903/R=0/SIG=­131jtnv35/*http://ww­w.freecreditreport.c­om/pm/default.aspx?P­ageTypeID=HomePage82­&sc=668061&bcd=YGROU­PSWHAT]
Yahoo! Groups [http://groups.yahoo­.com/;_ylc=X3oDMTJkc­mtpMWY1BF9TAzk3NDc2N­TkwBGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwNmdHIEc­2xrA2dmcARzdGltZQMxM­jIyODc5MTU4]
Change settings via the Web [http://groups.yahoo­.com/group/zms-devel­opers/join;_ylc=X3oD­MTJmZGMycXBtBF9TAzk3­NDc2NTkwBGdycElkAzg0­NzA4MjEEZ3Jwc3BJZAMx­NzA3MjgxOTQyBHNlYwNm­dHIEc2xrA3N0bmdzBHN0­aW1lAzEyMjI4NzkxNTg-­]
(Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest [mailto:zms-developers-digest@yahoogroups.com?subject=Email Delivery: Digest]
| Switch format to Traditional [mailto:zms-developers-traditional@yahoogroups.com?subject=Change Delivery Format: Traditional]
Visit Your Group
[http://groups.yahoo­.com/group/zms-devel­opers;_ylc=X3oDMTJkN­WFiYmpwBF9TAzk3NDc2N­TkwBGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwNmdHIEc­2xrA2hwZgRzdGltZQMxM­jIyODc5MTU4]
| Yahoo! Groups Terms of Use [http://docs.yahoo.c­om/info/terms/] |
Unsubscribe
[mailto:zms-developers-unsubscribe@yahoogroups.com?subject=] Visit
Your Group
[http://groups.yahoo­.com/group/zms-devel­opers;_ylc=X3oDMTJlN­HE0c2UyBF9TAzk3MzU5N­zE0BGdycElkAzg0NzA4M­jEEZ3Jwc3BJZAMxNzA3M­jgxOTQyBHNlYwN2dGwEc­2xrA3ZnaHAEc3RpbWUDM­TIyMjg3OTE1OA--]Yaho­o!
Finance

It's Now Personal [http://us.ard.yahoo­.com/SIG=13or3p4p4/M­=493064.12016257.124­45664.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288635­8/L=/B=ZCpMBELaX.c-/­J=1222879158505990/A­=4507179/R=0/SIG=12d­e4rskk/*http://us.rd­.yahoo.com/evt=50284­/*http://finance.yah­oo.com/personal-fina­nce]

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now. [http://us.ard.yahoo­.com/SIG=13odl6m50/M­=493064.12016308.124­45700.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288635­8/L=/B=ZSpMBELaX.c-/­J=1222879158505990/A­=3848643/R=0/SIG=131­q47hek/*http://searc­hmarketing.yahoo.com­/arp/srchv2.php?o=US­2005&cmp=Yahoo&ctv=G­roups4&s=Y&s2=&s3=&b­=50]

Reach customers

searching for you.

Family Photos

Learn how to best [http://us.ard.yahoo­.com/SIG=13o3igss0/M­=493064.12717544.130­24012.8674578/D=grou­ps/S=1707281942:NC/Y­=YAHOO/EXP=122288635­8/L=/B=ZipMBELaX.c-/­J=1222879158505990/A­=5370601/R=0/SIG=11l­nr7bf1/*http://advis­ion.webevents.yahoo.­com/familyographer/

capture your

family moments.

.[IMAGE]
__,_._,___

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Content Management System > AW: db size problem (4GB monster) 1 October 2008 20:39:11

see also:
Robustness
ConcurrentModificationException in…
Possible to merge fix for JGRP-136 to…
пройди тесты:
see also:

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .