Linking to an Oracle database

[fred]

I tried to link to an Oracle database using the ODBC
driver and found out that that performance is
exruciatingly slow. Is there any way to link to an Oracle
database without too much performance degradation? There
is a plan in using MS Access as a Front End to an Oracle
(back end) for a project at work.

 

[Jeff Boyce]

"Excruciating" is a relative term. I may become bored and lose interest if
a query takes more than 2 seconds to come back, while others may be willing
to wait for a minute.

You may want to take a look at Tony T's website for ideas about speeding up
connections.
http://www.granite.ab.ca/accsmstr.htm

You didn't mention the speed of your connection (LAN or WAN?), nor the speed
of your network, nor NICs. You didn't mention whether the selection
criteria and join fields are indexed in Oracle.

 

[fred]

Jeff,

Our organization is on a WAN with and T1 line.
The stations are on 100 Baud NIC setting. The
Oracle link was with a regular flat file.

The tests was done with two LINKED tables. These
tables were exactly the same (structure and number
of records). One table was in an ORACLE database
while the other table was in another MS Access (2000)
database. The 'front end' was a MS Access database.
After linking to these two tables to the 'front end',
two forms were created; each to access their own tables
respectively. Both databases ('back end') were located
remotely.

Finding a record from the MS Access table was
instantaneous while the ORACLE table took approximately
20 seconds. It there a more efficient way to link to
an ORACLE database to have a better response?


Thanks,
Fred

 

[Jeff Boyce]

Please take a look at Tony's ideas on connection issues. (see my previous
response)