Long type in Oracle
Using a Long type in Oracle causes pretty slow persistence. Now I'm not sure if the fault is with our Oracle config (I'm not a DBA, don't know too much about it) or if this is something normal.
Did a test on it today.
2030 characters inserted into a 'long' column 268 times, average: 3.58s, min: 3.23s, max: 6.27s.
Using same server and a CLOB type 268 times, average: 0.43s, min: 0.22s, max: 1.98s.
Odd, no?