×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"Sounds like your VB code is doing a new connection on each row. Each
connection creates a new QDZAOINIT job on the System i (or uses an
existing, unattached, prestarted QDZAOINIT job). That can get really,
really slow. Make sure your app is minimizing the connections."
Thanks for the suggestion, but we are not creating a new connection for
each row and actually we are reusing the same connection for ALL the
processing we do with the AS/400 files we deal with in this program and a
single connection for Access MDB. So we have the least possible
connections we can.
Peter Vidal
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com
"Sometimes your JOY is the source of your smile, but sometimes your SMILE
is the source of your joy."- Anonymous
midrange.com
