If i set the length under 10kb. I have nearly no effect. Because there are not so many documents under 10kb.
I would prefer to set the length between 20kb and 30kb (Thanks for the limitation hint).
Is it a good idea?
I am not sure that the performance will be better doing this.
The table will be bigger and the perfromance will be worse.. ????
The application manages the sampling process of automobil parts.
There are lots of information about parts, sampling plans, sampling results, person who are responsible for testing the parts etc.
In addition to that the person, who checks the part , can add documentation about that part after testing.
It is possible to see the document if needed.
I am in a migration phase from 9.5 to 9.7.
I saw the the new feature about small LOB's. And I try to find out if this feature applies to our program or not.
Partially-inlined LOBs are suitable for applications where a high percentage of the LOBs are very small sized (so that several can fit into a page). They are unsuitable for large documents, which are better suited for storage outside the database (but possibly linked from the database - as in some content management solutions).