Hello
I presetly porting a test system from MySql to Oracle. I'm doing this initially on a PC running XP and an Oracle 9 database. I have the MySql dbase on here as well.
Running a set of code against Mysql takes around 0.0055 sec, the same code takes 5.4 secs against the Oracle dbase. Using a timing function, I've found that 99.9% of the time is taken in the connection to the Oracle Dbase using Ora_Logon().
Does anyone know why the connection time is so horrific, all other calls to the Oracle Dbase take a miniscule time, comparable to the MySql Dbase calls.
A help here would be great, may be its an Oracle DBA question ?
Thanks chaps !
