Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle vs. MYSQL Performance

629827Mar 22 2008 — edited Apr 2 2008

Let me preface this by saying that I am very new to Oracle DBs. I rand a very simple test adding and selecting rows in a loop to see how Oracle compared to MYSQL. The results were not what I expected. Writing to a table with a sequence (auto increment in MYSQL) in batches of 10,000 rows (simulating what I will be using the database for) turned out a 350 insert per second number for Oracle. MYSQL was inserting at 5000+ per second for identical tables.

I know I am missing something here. How do you tune Oracle to get more performance? What am I missing here?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2008

Added on Mar 22 2008

2 comments

1,377 views