|
At 09:58 PM 3/14/2002, Vernon wrote: >A key point with ODBC is having indexes that support your queries. The application I am working with just writes to an AS/400 physical file via ODBC. I then access the AS/400 files via ILERPG. There should not be any indexes involved with the UPS writes. >Also, what is the app using? VB? MS Jet? OLE-DB? Or can you know? Jet is >one of the worst nightmares, as it goes to the absolute lowest denominator. Don't know, but can possibly check with UPS support. >I heartily recommend one of the Client Access ODBC manuals. The one from a >couple of releases back has some excellent chapters on making ODBC run better. Thanks. Will look for one of these. Dave Murvin DRM Enterprises, Inc. davem@drme.com
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.