|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.