Adobe Community : All Content - All Communities

Very slow Oracle Stored Procedure in ColdFusion 11

forums_noreply@adobe.com — Thu, 03 Jul 2014 20:03:14 GMT

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...

Repeated Call to CFC function is much slower than UDF version

forums_noreply@adobe.com — Mon, 23 Nov 2009 21:23:28 GMT

For a project we were confronted with an unexpected behaviour from a CFC. Without going to much into the details of the project it comes down to the following: when we run through a set of records, let's say 100, and apply a formatting function on it, the overhead is 4-5 extra seconds when we call it from an instantiated component (only once) compared to when we hardcode it as a UDF. Since our application can process several thousands of records in 1 pass the overhead quickly goes over 100 seconds compared to the UDF.

I was wondering if there's any logical explanation to this behaviour. From what I understood a function called from a component shouldn't add any noticeable overhead after the component has been instantiated.

Our setup is a Coldfusion 8 Jrun installation running on Linux. We couldn't really find anything on the web documenting this (or what we found told us there shouldn't be any extra overhead). We could change the function call to a UDF call but we prefer to keep it in a CFC as there's more going on behind the scenes than just formatting the data.

CAR deployment from Windows to Linux

forums_noreply@adobe.com — Sun, 19 Jul 2009 12:41:45 GMT

I have been trying to deploy a CAR which was built on my local Windows CF Development environment on a Coldfusion installation running on Linux.

For now I only create a file archive, leaving any server settings out. I FTPed the file to a remote Linux server after which I triggered the deploy process from the Linux CFIDE. I mapped the windows c:\.... folders to the linux /data/... and then pressed next.

This results in 2 issues:

1. recreating the folder structure results in a \ to / problem, making it inaccessible from the Linux filesystem. It does not replicate the folder structure as it should, but simply drops all the files into the same folder and creates a name like /data/.../images\myimage.gif instead of /data/.../images/myimage.gif.

2. during the deployment I get the following error:

"Error"

"07/19/09"

"02:19:42"

"[/opt/jrun4/servers/testcf/SERVER-INF/temp/cfusion.war-tmp/archive_properties.xml]java.i o.FileNotFoundException: /opt/jrun4/servers/testcf/SERVER-INF/temp/cfusion.war-tmp/archive_properties.xml (No such file or directory)"

I found little to no information about the above 2 problems. I'm hoping that someone can give me some more information on this and hopefully a fix/solution, one that does not involve setting up a local dev environment using Linux/CF.

FABridge for Flex2 Final

forums_noreply@adobe.com — Mon, 10 Jul 2006 17:57:35 GMT

I was wondering when the FABridge for the final Flex2 release will be out. I have been experimenting with the Beta3 version but after upgrading to the final release I started experiencing problems.
The main problem is that with Windows and using FF a Flex2 application that uses http binding goes wild when sending/retrieving data over the bridge. This still works fine with Beta3 and the Beta3 player. Strange enough it works fine with IE. On a mac or linux box it works with all browsers, including FF. It's like something is conflicting in the FP9 and the current version of FABridge, although this is still speculation.
I noticed similar problems with Opera, which uses the same flash player plugin as FF. (I expect that every browser using that plugin, so not the ActiveX one) will be affected by this behaviour.

I'm not sure what the response on this topic will be. I can't say that this forum is very lively :)

B.

Problem with TabNavigator and removing childs

forums_noreply@adobe.com — Fri, 14 Jul 2006 11:02:24 GMT

I'm working on an application which uses states. One of the states implements a TabNavigator component where I add and remove childs (other custom mxml components) on the fly. This adding and removing works fine. But when I change the state of the application and go back to the TabNavigator state the application freezes. If I leave 1 child in the TabNavigator and switch states and eventually go back it works just fine. But when all childs are removed it gets stuck. I have tried to remove the last child in different ways but they were all unsuccesful. This is how I currently do it:

public function removeNavChild(cid:String) : void {
var childToDelete :DisplayObject = navigator.getChildByName(cid);
if ( childToDelete ) {
if ( navigator.numChildren == 1 ) {
navigator.removeAllChildren();
quit();
}
else
navigator.removeChild(childToDelete );
}
}
private function quit() : void {
Application.application.currentState = "login";
}

Am I missing something here or is this another bug? Any input would be highly appreciated.

B.

ExternalInterface + Firefox problems

forums_noreply@adobe.com — Wed, 12 Jul 2006 11:48:00 GMT

I have already mentionned this on the Flash Player forum but I was wondering if others experience the same.
I'm working on a project that implements a Jabber chat client. The primary connection method is an XMLSocket. However, a FW disabling direct access can block that type of communication (even when one uses proxies) so we came up with a backup connection mechanism for when the socket fails, namely HTTP Binding.

This uses JavaScript to send and retrieve information to/ from the Jabber server. I started work on this when Beta3 came out and it was working just fine until monday, when I decided to install the trial version of Flex2 and the final Flash player 9 version for both IE and FF while waiting for the official license pack I ordered last week.

After testing with the 'final' product I noticed that the application under FF (and all the other browsers that don't use the ActiveX plugin for the player) started to show performance issues when connecting via http binding. First I thought it was because I was using the FlexAjaxBridge which is not up to date but after removing that one and implementing my own ExternalInterface approach I noticed the same behaviour.

Basically, what happens is that when I call the JScript function for the 3rd time the Flex application freezes. After a while it recovers but next time I execute the function again it freezes again, but for a longer time. And so on until the application hangs for ever. What's weird is that if I type something in a text field it is send over to JS and it receives data, but the Flex application doesn't display it because of this (semi) freezing state. Probably doesn't make a lot of sense :)

I tested this with Opera and I have the same behaviour there. With IE it works perfect as it did with Beta3.

Now what's even more interesting is that at work we have a couple of Mac boxes. So I figured to test it on those and there it does work with FireFox! (not with Safari but that's because it doesn't support the Ajax stuff).

Anyway, it's a bit annoying that something which worked just fine with Beta3 seems to fail now. I'm still trying to figure out what the best contact option is to bring this up with Adobe. Any suggestions would be appreciated.

B.

p.s.: Any news on the Linux version of the Player? :)