Recently I installed ColdFusion 11 Developer version (on Windows 8 & IIS) to test the migration of a CF9 based website that uses Oracle as its underlying DB. 1 of the first problems I encountered are the PLSQL stored procedures that seem to be very slow, like 10-50 times slower than with CF9. So I did a test where I execute the exact same SQL statement, which returns ~11000 rows, with both cfstoredproc and cfquery. The processing time of the stored procedure is 111645ms while the processing time of the cfquery is 362ms. The query doesn't return any (C)LOBs, per row there are 4 columns returned, 3 having a number, 1 having a varchar2 with a max size of 256 characters. I uninstalled CF11 several times but everytime I get the same results, no matter what I try in the CFIDE. Maybe I'm missing something obvious here, but for now I don't see it...
1
Reply
AdChoices