Trying to "prettify" the result is a reason to move away from CSV.converting to XLS before running out of Java heap space. We wanted nice
But, I have a process that just took forever with a vendor product
SYSCOLUMNS for the first row so it presented that part nicely.
The fix was to output it as CSV but I retreive the column headings from
This is such a common task - why does it seem so difficult to get a simple
Date: Wed, 2 Jul 2014 16:25:05 -0400
Subject: Re: Question on using SQL2JXL in multiple concurrent jobs
On Wed, Jul 2, 2014 at 3:49 PM, Nathan Andelin <nandelin@xxxxxxxxx>
moving away from SQL2XLS to SQL2JXL, due to performance issues with
I think that such performance problems are quite common withI don't think the "particularly when Java is involved" is a fair
utilities which dynamically format the results of SQL queries into
some other format... particularly when Java is involved.
assessment. Both SQL2XLS and SQL2JXL "involve Java". Yet SQL2JXL is
noticeably faster. The main thing that makes some POI-based
solutions slow is the RPG-to-Java interface. The more you have to
call Java from RPG, the bigger the overhead. Native Java is... well,
not as fast as pure C or pure RPG, but not as slow as Java-through-RPG.
And then of course there can be better and worse algorithms even
within one implementation language that can affect performance.
Have you considered streaming SQL result sets to .CSV instead?Usually, CSV is one of the earlier ideas people come up with. Folks
turn to Excel mainly when CSV's shortcomings become deal-breakers.
But yes, if CSV is adequate, then it's a much faster-performing
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact