Tuesday, May 13, 2008

Performance problems concatenating LOBs

Greg Pike talks about some potential performance pitfalls with LOBs; I would comment on his blog, but it's a login only. Anyway, I posted on these problems last year (specifically with DBMS_LOB.APPEND), and posted some code to deal with it. Batching up appends makes a big difference - a 15-20 fold improvement, in the example shown (against 9.2.0.5).

1 comment:

Greg said...

I have changed the settings on www.singlequery.com to now accept comments without logon. Thanks for mentioning this!

Greg Pike