posted 19 years ago
Hi everyone, i developing an application that downloads information of different databases and create plain text with that information.
Each 200,000 records, i going to the text plain and write the contents of a StringBuffer, and create a new one to continue record information in it.
In Oracle, my code work fine, with a table of 5,600,000 records, but in mysql, i get java.lang.OutOfMemoryError, even with much less records than in oracle.
My query in mysql is SELECT * FROM afiliados limit 500000, i try to record in the file each 50,000 records, but the results are the same.
My code is the following :
Please help me in this situation,
Thanks and Regards,
[edited to add code tags]
[ March 05, 2005: Message edited by: Jeanne Boyarsky ]
Luis Felipe.<br /> <br />SCJP, SCWCD.