Question about prepared statements

2010-07-21 Thread Marco Ferretti
Hello, I have a question on how derby works with prepared statements. The scenario : -1 connection (embedded driver) -1 prepared statement run several times over the database ( does not matter if select, insert ... ) -I keep the connection open but close the prepared statement ( and make sure it i

Re: Reducing memory footprint of embedded Derby

2010-07-21 Thread Mike Matrigali
David Van Couvering wrote: Thanks, Mike I am doing some of that, and am looking into doing more of that. But it's more than possible that I'll have a lot of open, *active* databases. We're talking a lot of data, potentially 10s of GB of BLOBs. I was concerned a single Derby DB would not b

Re: Reducing memory footprint of embedded Derby

2010-07-21 Thread David Van Couvering
OK, thanks, very useful. David On Wed, Jul 21, 2010 at 1:56 PM, Mike Matrigali wrote: > David Van Couvering wrote: > >> Thanks, Mike >> >> I am doing some of that, and am looking into doing more of that. >> But it's more than possible that I'll have a lot of open, *active* >> databases. >> We're