Hi,
I have successfuly written CLOB support into my PHP4-based BBS app using an Oracle 8i database. It can read and write to the CLOB perfectly, and for every insert I'm using bind variables (via the OCI fucntions).
Question is: how efficient are CLOBs at storing a) data under 4001 characters and b) data over 4000 characters? As I understand it CLOBs get stored inline with the row if the insert string is under 4001 characters and elsewhere if they are over. But: if I *always* use bind variables will they always get stored elsewhere or does Oracle still determine storage itself?
Basically I don't want any performance or storage issues to negate the benefits of using a CLOB. The BBS may grow to hundreds of thousands of messages (98% of which will likely be less than 4000 characters). I hope I can just insert everything the same way and have the CLOB basically work like a VARCHAR2(4000+). Does that make sense?
Thanks for any feedback...
I have successfuly written CLOB support into my PHP4-based BBS app using an Oracle 8i database. It can read and write to the CLOB perfectly, and for every insert I'm using bind variables (via the OCI fucntions).
Question is: how efficient are CLOBs at storing a) data under 4001 characters and b) data over 4000 characters? As I understand it CLOBs get stored inline with the row if the insert string is under 4001 characters and elsewhere if they are over. But: if I *always* use bind variables will they always get stored elsewhere or does Oracle still determine storage itself?
Basically I don't want any performance or storage issues to negate the benefits of using a CLOB. The BBS may grow to hundreds of thousands of messages (98% of which will likely be less than 4000 characters). I hope I can just insert everything the same way and have the CLOB basically work like a VARCHAR2(4000+). Does that make sense?
Thanks for any feedback...