Re: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Paul Libbrecht
David, I do not see any other way than programmatically separating the lines of the SQL query. Is this doable ? Like, if it's a backup, it probably has a chance that each query is a line, or ? If yes, then it should be pretty easy to use a LineNumberReader and feed each line as an SQL

RE: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Karr, David
parameters. Watching the task manager, the memory usage slowly increases as it inserts rows. -Original Message- From: Paul Libbrecht [mailto:[EMAIL PROTECTED] Sent: Monday, July 09, 2007 4:13 PM To: Jakarta Commons Users List Subject: Re: [jelly] How to make a large Jelly-SQL script

RE: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Karr, David
a large Jelly-SQL script more memory efficient? Oh, sorry, hadn't grasped, but then I doubt jelly can do anything... am I wrong or it is normal for an SQL driver to keep an amount based in memory as long as the transaction is not committed ? Do you see something jelly code that stores