What are some tips to optimize performance when working with LOBs in OCI?
• Use an array bind to perform INSERTs. • Use an array fetch to retrieve all LOB locators. • Open multiple connections to the same database, and parallelize the INSERTS, FETCHES, OCILobWrites(), and OCILobReads() on these connections. • Turn logging off when loading or unloading 300 to 400 GB of LOB data. • Use the maximum Oracle block size and chunk size (32 k) if the individual LOBs are large. • Use a different tablespace for TIFF BLOB DATA, TIFF BLOB INDEX, SGML CLOB DATA, and SGML CLOB INDEX. • Since LOBs are big, you can obtain the best performance by reading and writing large chunks of a LOB value at a time. • Use LOB buffering if you need to read/write small pieces of LOB data on the client. • Use OCILobWrite() and OCILobRead() with a callback so data is streamed to or from the LOB. Ensure that the length of the entire write is set in the amount parameter on input. Whenever possible, read and write in multiples of the LOB chunk size. • Use a checkout/checkin model for LOBs. LOBs
Related Questions
- When I use EtherPeek to monitor my high speed network, the application tends to slow down. Are there any tips to optimize performance?
- Are there tips for using Microsoft Internet Explorer (IE) to optimize UPS Internet Shipping performance?
- What are some tips to optimize performance when working with LOBs in OCI?
