Geert, Thanks for the quick reply. I should have added some additional info:
- This is in a noncaching pipeline with outputBufferSize=256000 - From the mysql client, the query begins to return rows almost immediately. - Using the status link in the samples, I can see the JVM memory usage growing to the size of the total result set. - I can remove the stx transform and the xsp sill caches. Is there any way to get more visibility on what is going on inside the xsp generator? Joel Joel McConaughy Managing Partner Displayware LLC 800 Fifth Ave., #101-316 Seattle, WA 98104-3191 206-300-4732 Direct 206-382-2188 Fax [EMAIL PROTECTED] -----Original Message----- From: Geert Josten [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 7:12 AM To: [email protected] Subject: Re: Is ESQL/xsp supposed to stream? Hi Joel, Several cases are possible. Are you sure the xsp generator is caching, or does esql simply take a lot of time to gather the table and starts looping over the records only once it has received them all? Secondly, stx transformer could cache as well. Finally, there are options with which serializers can be told to 'cache' results as well, to be able set a correct value for the content-length field. I think you should start with adding logging instructions to your xsp page, to help clarify whether the time delay occurs in the xsp (and where) or after the xsp step... HTH, Geert Joel McConaughy wrote: > I'm trying to use the serverpages generator with ESQL and the stx > transfomer to process large database tables. The serverpages > generator is not streaming but rather caches the entire contents of > the query before passing data to the stx transformer. Is this > expected behavior? Is there a way to configure this to stream the > results? > > Thanks, Joel > > cocoon 2.1.7, jdk1.4.2_08, mysql4.1.11, mysql_connectorj3.1.10 > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- [EMAIL PROTECTED] IT-consultant at Daidalos BV, Bleiswijk (NL) http://www.daidalos.nl/ tel:+31-(0)10-850 12 00 fax:+31-(0)10-850 11 99 GPG: 1024D/12DEBB50 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
