I am experiencing a problem with a recently launched v4 site. The postgres database is experiencing constant growth which doesn't seem right as I know there's no content changing.
The first group of inserts I'm concerned about are in the attached file http://www.nabble.com/file/3953/alternative_page_title_INSERTS.txt alternative_page_title_INSERTS.txt . This same block of inserts seems to be occuring for every page request. Is this normal? I'm guessing the inserts are related to a template include file http://www.nabble.com/file/3954/page_title.jsp.txt page_title.jsp that lets the user set an alternative page title. Is there anything about my logic that could cause this to happen? The second problem was causing much larger db growth. I have template that accepts query string parameters with category id's. The template then uses these id's to pull xml data from an external source. An URL for this page might be in the form of : /edna/go/resources/browse?id=2341&catpath=0,1234,4231,2341 I also had some apache rewrite rules to handle some legacy URL's from a previous system: a URL like /edna/browse/0,1234,4231,2341 was rewritten to the above url RewriteRule ^/edna/browse/([0-9]*)\,([0-9:]*)$ /edna/go/resources/browse/cache/bypass\?id=$2\&catpath=$1\,$2 [R] However when these rules are in place, the database experiences massive growth, around 200-400KB per hour. I compared sql dumps ( http://www.nabble.com/file/3956/jahia410edna_20061102-15_00.zip 3pm , http://www.nabble.com/file/3955/jahia410edna_20061102-16_00.zip 4pm ) of the database an hour apart and found the records that had been added. Referring to http://www.nabble.com/file/3955/jahia410edna_20061102-16_00.zip jahia410edna_20061102-16_00.sql in attached zip file : - jahia_field_defs table inserts, line 178341 is where the hour's worth of new records starts. - the field values have numbers appended that are all category id's from our external data repository: 45536 1 boxContent20399,20439,4710,4783,4787,4787 45537 1 boxHeadingLevel20399,20439,4710,4783,4787,4787 45538 1 boxTopOfPage20399,20439,4710,4783,4787,4787 45539 1 boxBrowseSubtitle20399,20439,4710,4783,4787,4787 45540 1 boxBrowseCatpath20399,20439,4710,4783,4787,4787 ... etc. about 2000 records added, plus records in other tables. Disabling the apache rewrite rules dramatically decreases the growth of the db, but it is still growing slowly due to the inserts from the first issue. I appreciate any help you can provide with this problem. -- View this message in context: http://www.nabble.com/Constant-database-growth-tf2565295.html#a7150330 Sent from the Jahia - Dev mailing list archive at Nabble.com.
