Hi,
Cocoon 2.0-dev version have several memory-related bug fixes. Wait for 2.0-rc or get
snapshot from http://cvs.apache.org/snapshots/xml-cocoon2/ or download latest
cocoon from CVS and repeat your testing.
Vadim
> -----Original Message-----
> From: Rune Sandnes [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 02, 2001 10:53 AM
> To: [EMAIL PROTECTED]
> Subject: Problem with C2 memory usage
>
>
>
> We have some problems with memory usage in Cocoon2b2 on Windows 2000
> with IIS and Tomcat 3.2.3.
>
> Everything works fine for a while, but after a number of accesses the
> amount of memory Cocoon uses grows really big (e.g. 180MB) and things
> work slower and slower. We have to restart tomcat to get Cocoon to start
> responding again.
>
> It might seem like it never does garbage collection.
> I use the default settings from the installation, and I have also tried
> to disable caching to see if that could be a source of memory leekage.
>
> The problem arises with database access from xsp files, when I do stress
> testing with a simple xml file it works fine, the memory usage grows
> much slower anyway.
>
> The esql xsp page I use is included below. Is there anything really,
> really wrong here?
> Could it be something else in my setup?
>
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <xsp:page
> language="java"
> xmlns:xsp="http://apache.org/xsp";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >
>
> <page>
> <esql:connection>
> <esql:pool>poolnamehere</esql:pool>
>
> <!-- Document data -->
> <esql:execute-query>
> <esql:query>select * from documents where id =
> <xsp:expr>request.getParameter("id")</xsp:expr></esql:query>
> <esql:results>
> <esql:row-results>
>
> <content>
> <dokid><esql:get-int column="id"/></dokid>
> <esql:get-xml column="doc_data"/>
> </content>
>
> </esql:row-results>
> </esql:results>
> </esql:execute-query>
>
>
> <!-- News column -->
> <esql:execute-query>
> <esql:query>SELECT TOP 3 LEFT(documents.title, 30) + '...' AS title,
> id FROM documents INNER JOIN doc_locations ON documents.id =
> doc_locations.document_id AND doc_locations.location = 'news' AND
> documents.status = 'A' ORDER BY documents.create_date</esql:query>
> <esql:results>
> <news>
> <items>
> <esql:row-results>
> <item>
> <id><esql:get-int column="id"/></id>
> <title><esql:get-string column="title"/></title>
> </item>
> </esql:row-results>
> </items>
> </news>
> </esql:results>
> </esql:execute-query>
>
>
> <!-- Menu -->
> <esql:execute-query>
> <esql:query>SELECT * FROM document_tree</esql:query>
> <esql:results>
> <menutree>
> <esql:row-results>
> <item>
> <id><esql:get-string column="id"/></id>
> <parent_id><esql:get-string
> column="parent_id"/></parent_id>
> <name><esql:get-string column="name"/></name>
> </item>
> </esql:row-results>
> </menutree>
> </esql:results>
> </esql:execute-query>
>
>
> <!-- Documents in this category -->
> <esql:execute-query>
> <esql:query>SELECT LEFT(documents.title, 25) + '...' AS title, id
> FROM documents INNER JOIN doc_locations ON documents.id =
> doc_locations.document_id AND doc_locations.location = 'companyinfo' AND
> documents.status = 'A' ORDER BY documents.create_date</esql:query>
> <esql:results>
> <otherdocs>
> <esql:row-results>
>
> <od>
> <id><esql:get-int column="id"/></id>
> <title><esql:get-string column="title"/></title>
> </od>
>
> </esql:row-results>
> </otherdocs>
> </esql:results>
> </esql:execute-query>
>
>
> </esql:connection>
>
> </page>
>
> </xsp:page>
>
>
> --
> Regards,
> Rune, Trondheim, Norway
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
