Migration of MSaccess-DB to OracleDB, but Oracle-DB response time was longer?!?!?

Home -> Community -> Usenet -> c.d.o.misc -> Migration of MSaccess-DB to OracleDB, but Oracle-DB response time was longer?!?!?

From: Gerald Wippel <gw_at_flexaut.tuwien.ac.at>
Date: Mon, 8 Mar 1999 17:34:12 +0100
Message-ID: <7c0u69$9ob$1@news.tuwien.ac.at>

Hi Expers!

I migrated a MSaccess 2,0 database to a Oracle 8.0.4 database. I connected via ODBC to both databases and determined the response time of SQL-commands (Select (joins, righter and left joins). insert, update, delete, ...). The response time of SQL-commands to the Oracle-DB were longer as the SQL-commands (Select) to the MSaccess DB. The used tables have between 400 and 50 000 rows.

Can anyone explain this effect or give me tips to remove the bottleeck.

Thanks,

Gerald Received on Mon Mar 08 1999 - 10:34:12 CST