Re: Oracle v7, ODBC, and VB
From: Rob Ryan <rryan_at_panix.com>
Date: 8 Nov 1993 19:02:18 -0500
Message-ID: <2bmmma$ne6_at_panix.com>
Date: 8 Nov 1993 19:02:18 -0500
Message-ID: <2bmmma$ne6_at_panix.com>
In <931108121510_at_dlpc030.dlogics.com> dlm_at_elcky (Dave Mausner) writes:
>>I would like to avoid using ODBC, if possible.
>
>cannot imagine why, since it works and adds almost no overhead.
>we use it here, so don't argue with me about it ;-)
Tell us your secret, please. I find that retrieving large amounts of information (a very simple query, no joins, two fields, 30k records) is about 6 times slower using Access/ODBC than Powerbuilder v2.0. VB (using direct ODBC calls, not Access's engine) was 10-15% faster than Access, but still notably slower than Powerbuilder.
What's your configuration? We're using Novell's Lan Workplace in conjunction with Oracle's SQL*Net for Windows (TCP/IP).
- Rob