| | |
|
|
|
Linking to an Oracle database |
|---|
| message from fred on 1 Jun 2004 |
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 replied to fred on 1 Jun 2004 |
"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 replied to Jeff Boyce on 2 Jun 2004 |
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
and lose interest if
others may be willing
about speeding up
WAN?), nor the speed
the selection
|
| Jeff Boyce replied to fred on 2 Jun 2004 |
Please take a look at Tony's ideas on connection issues. (see my previous
response)
|
|
Archived message: Linking to an Oracle database (Microsoft Access Forms)
