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="readbinary" file="#trim(docfound)#" variable="myBinary">
<cfquery datasource="#session.sf_datasource#">
UPDATE BDD_CLOB
SET CLOB_CONTENT = <cfqueryparam value="#ToBase64(myBinary)#" cfsqltype="CF_SQL_CLOB">
WHERE CLOB_ID = <cfqueryparam value="#clobID#" cfsqltype="CF_SQL_NUMERIC">
</cfquery>
Thanks!
Jami
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="readbinary" file="#trim(docfound)#" variable="myBinary">
<cfquery datasource="#session.sf_datasource#">
UPDATE BDD_CLOB
SET CLOB_CONTENT = <cfqueryparam value="#ToBase64(myBinary)#" cfsqltype="CF_SQL_CLOB">
WHERE CLOB_ID = <cfqueryparam value="#clobID#" cfsqltype="CF_SQL_NUMERIC">
</cfquery>
Thanks!
Jami