0 Replies Latest reply on Jan 31, 2007 8:39 AM by Rob_Ceelen

    BLOB retrieval problems

      For security reasons we store some of our information (pdf, tiff, jpeg) into BLOB fields in Oracle. We retrieve these as described in Forta's Blog. Small files are no problem but we also have files up to 60Mb. This of course will take some time to retrieve from oracle but the problem is that during this time coldfusion consumes about 80%~100%% cpu load. Multiple requests for these files result in a 'hung' server. Is there a way to minimize the load for Coldfusion??? We have a windows 2003 environment with coldfusion 7.02