-Adam
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 11:16:02 -0400
Subject: OT: Oracle 9i
To: CF-Talk <[EMAIL PROTECTED]>
If I have am building an extremely large string (40,000 chars) in a PL/SQL
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]
