RE: AS/400 Toolkit - Closing Files

After further investigation the situation is worse.  It seems that when we
recreate a Statement object and redo a query to a file that was previously
left open we are opening a new instance of the file and not reusing the old
one.  Thus, there is the potential of having the same file open many times.

/Tim


> -----Original Message-----
> From: Timothy Sullivan [SMTP:TSullivan@computer-guidance.com]
> Sent: Wednesday, May 03, 2000 9:49 AM
> To:   JAVA400-L@midrange.com
> Subject:      RE: AS/400 Toolkit - Closing Files
> 
> Dave,
> 
>       You have a good point that we have discussed.  What are the
> negatives to leaving the files open on the AS/400?  We can possibly query
> many files (+100 an increasing all the time) when running the application
> so
> the question becomes what is the impact when we have multiple users
> querying
> multiple files.  It may just be that it better to leave them open but it
> very hard to judge since we have no good way to measure the pros and cons.
> 
> /Tim
> 
> > -----Original Message-----
> > From:       Leland, David [SMTP:dleland@Harter.com]
> > Sent:       Wednesday, May 03, 2000 7:02 AM
> > To: 'JAVA400-L@midrange.com'
> > Subject:    RE: AS/400 Toolkit - Closing Files
> > 
> > Timothy: 
> > 
> > Are you sure you want the files to close?  We are doing something
> similar
> > and the files stay open so they can be reused again.  It speeds up
> > processing tremendously.  It has something to do with a "persistent"
> > connection, I believe.
> > 
> > Dave 
> > 
> > 
> > 
> 
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---