Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

tobase64 taking a lot of time to process

Status
Not open for further replies.

Jami

Programmer
Jul 18, 2000
54
US
Hi all,
I am reading a file in binary mode and updating a database table with a clob field using this read and the tobase64 function. This routine is working great for about 70% of my records. Every once in a while, it is taking an extremely long time to process (up to nearly 7000 milliseconds at times) or the application page will end up no longer responding. With these lengthy process times, the file usually cannot be retrieved again from the database. Can anyone offer any help? Some of the code has been included below. The update query is the reason for the page's long processing time:

<cffile action=&quot;readbinary&quot; file=&quot;#trim(docfound)#&quot; variable=&quot;myBinary&quot;>

<cfquery datasource=&quot;#session.sf_datasource#&quot;>
UPDATE BDD_CLOB
SET CLOB_CONTENT = <cfqueryparam value=&quot;#ToBase64(myBinary)#&quot; cfsqltype=&quot;CF_SQL_CLOB&quot;>
WHERE CLOB_ID = <cfqueryparam value=&quot;#clobID#&quot; cfsqltype=&quot;CF_SQL_NUMERIC&quot;>
</cfquery>

Thanks!
Jami
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top