Thanks to @SQLPerfTips for pointing out a video on “OLTP Performance – The Trouble with Parsing” from #oracle

From @SQLPerfTips, picked up an interesting video on OLTP Performance – The Trouble with Parsing.

The video was a demonstration of a test application which does a transaction consisting of a SELECT, an INSERT, and an UPDATE.

What really impressed me was the differences in the simulated transaction rates as the test application was reconfigured. My summary is below:

Parsing Connection Pooling Transaction Rate
None Yes 30,000
Soft Yes 20,000
Hard Yes 3,000
Hard No 300

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s