stored procedure. Would it be better to keep concatenating a variable of a
CLOB datatype? Or build 10 varchars and concatenate them at the end into a
CLOB?
I have noticed that my stored procedure runs very slow using the clob. if I
use a single varchar(4000) the procedure runs very fast. If I limit the data
to 4000 chars and do the same with a clob it runs very slow.
The way I am doing this is concat(ClobString, 'some more text') over and
over and over again. Slow....
Thanks,
David
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
