|
This is one of those loaded questions that I have to answer: "It depends on what you want to do and how well your database is indexed". If you are doing lots of queries where there are existing indexes, the performance can be be sub-second. If you are doing lots of queries where there are no indexes it will be slow as molasses. Tell us more about what you're trying to do and also start doing some real-world experimentation. No better way to learn than to get your feet wet. Regards, Richard Schoen RJS Software Systems Inc. "Providing Your....iNFORMATION NOW!" Email: richard@xxxxxxxxxxxxxxx Web Site: http://www.rjssoftware.com Tel: (952) 898-3038 Fax: (952) 898-1781 Toll Free: (888) RJSSOFT ----------------------------------------------------------------------------------------------- What's the prevailing wisdom backed up by real world experience when using ODBC from whatever tool or programming language to access DB2/400 or ORACLE versus using some other remote or distributed access method such as DRDA, calls to stored procedures or API calls? I've been told that ODBC is a good performer but have my doubts. What's your experience show vs Ivory Tower tests? Thanks in advance,
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.
midrange.com
