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).
Subscribe to:
Post Comments (Atom)
1 comment:
I have changed the settings on www.singlequery.com to now accept comments without logon. Thanks for mentioning this!
Greg Pike
Post a Comment