Re: Oracle performance decrease using Access7

Well, you've got all CHAR fields, which are fixed-length. This is bad. This means that the server and ODBC driver have to pass 300 bytes of information for each row, regardless of whether they're empty or not. Access is most likely then trimming/truncating these fields for display, which takes time.

I notice no significant difference here between queries done through Access 97 (with ODBC 8.0.4.0.2) and through ODBC Test. It's probably the type of columns you are using. If it were me, I'd change them all to VARCHAR2 and never use CHAR again.

Troy Perchotte wrote:
>
> I have two NUMBER fields, both length of 10 with 0 Precision. The remaining
> 8 fields are all CHAR datatype with lengths of 50, 60, 60, 60, 20, 2, 30,
> and 10.
>
> The server is a Dual Pentium machine with two 100MhZ processors. It's
> running NT Server 4.0 and Oracle Workgroup Server 8.04. Since this server
> is a test server, there is very little traffic happening from it.
>
> The client machine that I am operating from is a P-120 running NT
> Workstation 4.0 with Oracle Client 8.04, connected to the server through a
> 10BaseT LAN.
> .
> Access 7 is connected via the Oracle 8.00.0400 ODBC driver.
>
> I tried asking Oracle about this issue, but was told that since the ODBC
> test was instantaneous that I would have to talk to Microsoft. The
> Microsoft Access team were unable to resolve the problem.
>
> Is it normal though, that the display time increases dramatically with the
> number of fields in a table?
>
> H. John C. Hopkins wrote:
>
> > Troy:
> >
> > Weird. Viewing a table with 10 fields should provide a nearly
> > instantaneous response. Even 2 seconds is slow. What sort of datatypes
> > are used in these fields? You'd have to be sending a LOT of info down
> > the pipe to have a response time that slow.
> >
> > What's your setup? Which version ODBC driver are you using?
> >
> > -J
> >
> > [This followup was posted to comp.databases.oracle.misc and a copy was
> > sent to the cited author.]
Received on Tue Apr 14 1998 - 19:27:26 CDT