CLOB Performance Issues
Posted on 2001-07-25
I have a table with one CLOB column and currently the table has 80 records.We are expecting the table to have around 30000 records.For now we do not have any CLOB value more than 4500 bytes,the maximum value we are expecting for this CLOB is 50000 bytes.95% of the CLOB usage is read only. What kind of performance problems we might have in future as the table grows.
When specifying the CHUNK size for the CLOB what block size does it refer to, is it the Oracle block size,filesystem block size or operating system block size.
I have seen some doccumentation about the LOB SUBSYSTEM BUFFERING which says 'LOB SUBSYSTEM BUFFERING enables the web server and client side applications to buffer the contents of one or more LOBs in the client's address space' will this help in my case, because 95% of the CLOB usage is read only.
we are using this in an internet application, each time the page is refreshed the CLOB values are accessed, so i am concerned about the performance issues i might have in future.
Are there any additional parameters which i need to consider in matters of performance.
Thanks in advance.