Re: Oracle performance decrease using Access7

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.]

perchott_at_nospamdigitalcourier.com says...
> I am trying to port an Access database to oracle. Their main table has
> 106 fields in it. After attaching the table in Access7, it takes about
> 30 seconds just to view the table, regardless of the number of records.
>
> When I reduced the number of fields to about 20, Access then took about
> 8 seconds to display the data. After reducing it to 10 fields, I was
> able to get a satisfying 2 seconds.
>
> I checked the ODBC connection using Oracle's test utility, and found the
> data to be displayed instantly even with all 106 fields (although the
> utility is limited to 100 fields). I haven't found anything weird in
> the trace log either (however, I'm not really sure that I know what to
> look for in there).
>
> Is this normal? This is my first Access conversion. Does this happen
> to everyone else?
>
> Troy Perchotte
>
>
Received on Mon Apr 13 1998 - 13:09:30 CDT