[ajug-members] oracle slowness

[Rob Kischuk]

No suggestions on the driver front, but... not all database slowness 
comes from the driver.  If you're doing simple operations - 
selects/updates on single tables, most any database is going to slow 
down compared to MySQL, since MySQL's tables are (by default) flat files 
that can be zipped through quickly.  A strength and a weakness of Oracle 
is its tunability - it has a broad variety of config parameters that can 
make its performance very fast or very slow.  That's one place I'd look 
- Oracle can be easily misconfigured to be deceptively slow.

Another place I'd look for speeding up your Oracle performance is adding 
in the foreign key relationships that MySQL (by default) doesn't 
support  - this will help the query optimizer solve queries better in 
some situations.  Lastly, see if your tables could benefit from 
indexes.  See what fields your selects and updates are based on.  If 
they are fields tagged as primary key or index, that's good.  If not, 
understand that Oracle may do a full table scan to find your answer - 
that's bad, and generally slower than MySQL (using MyISAM).  If adding 
an index makes sense, do it, understanding that too many indexes can 
also hurt performance.

These may be things you already know, but I did want to add reasons 
other than the driver that you could be seeing this performance drop-off.

-Rob

Barnes, Michael wrote:

>Currently, I am porting a hibernate 2.1.7 project from MySQL to ORACLE 8i
>and notice that I am getting a significant performance degradation by going
>to oracle. 
>
>Could someone sugesst a good driver (i am using classes12.zip)
>
>Thanks 
>Mike Barnes 
>_______________________________________________
>ajug-members mailing list
>ajug-members at ajug.org
>http://www.ajug.org/mailman/listinfo/ajug-members
>  
>