cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <DHo...@csir.co.za>
Subject Returning large datasets via SQL Transformer?
Date Tue, 15 Mar 2005 09:36:15 GMT
Using Cocoon 2.1.6 on Linux...

I am having a problem attempting to return a large
set of data, via the SQL transformer, from a MySQL
database, through Cocoon.

A query such as :
SELECT * FROM mytable LIMIT 100
works fine, but if I remove the limit and attempt to
retrieve the entire table - some 25000 rows of 30
floating point data fields - I just get an empty file.

Is there a limit built-into either  the SQL transformer
or Cocoon that needs to be changed to allow a 
larger volume of data to be downloaded

Thanks
Derek

PS Yes, I do have to have the entire record set...

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message