Daryl's ColdFusion Notes

Daryl, What a pain it was trying to get coldfusio...

2009-06-16T11:05:22.537-05:00

Daryl,

What a pain it was trying to get coldfusion installed and running until I finally found this page. It worked great.
Thanks.

One other thing for you...I'm having an issue with...

2009-04-21T19:14:00.000-05:00

One other thing for you...I'm having an issue with connections not closing.

I see that you're calling cnx.close() in a cfcatch, but I don't see it being called anywhere else. Just thought I'd let you know.

I was playing with your jdbcQuery tags, and I noti...

2009-04-21T13:27:00.000-05:00

I was playing with your jdbcQuery tags, and I noticed in the jdbcQueryTest.cfm file you sleep for 4 seconds, and I was wondering why you were doing that.

Thanks!!

2009-01-28T16:48:00.000-06:00

Thanks!!

@Mike,1) They're all regular datasources that poin...

2009-01-28T16:33:00.000-06:00

@Mike,

1) They're all regular datasources that point to a regular database.

2) I didn't keep copies of the results of those tests-- and even if I had, it would have been a nightmare to get publishing permission from the Fortune 500 company involved. I guess that makes me something of a hypocrite, since I complained in my original post about no testing methodology being shown, but I'll find a way to live with that pain. ;)

Thanks again, Daryl.I'm still hoping for a couple ...

2009-01-28T15:14:00.000-06:00

Thanks again, Daryl.

I'm still hoping for a couple more answers...
1) The "identically-configured datasources" - they all point to the same one database instance, correct? They do not point to some sort of a clustered database environment, right?

2) Do you have any sort of data/results from your tests that we can all see?

You rock,
Mike

Daryl, I should have noticed that you used the Buf...

2009-01-24T00:34:00.000-06:00

Daryl, I should have noticed that you used the BufferedOutputStream -- I skipped right over it. Do you think it would be more efficient if the buffer size was set higher than 512 bytes which is the default if you don't pass one in the constructor? I know that the flush() method can be a little expensive and I assume that is being called each time internally when the buffer hits the threshold.

Thomas,ColdFusion applications don't run inside II...

2009-01-23T16:23:00.000-06:00

Thomas,

ColdFusion applications don't run inside IIS; instead, there's a connector that forwards requests to the ColdFusion Application Server service for processing. The "wsconfig" connector installer that comes in the 64-bit version of ColdFusion is (in my experience) much better at making the connector work with IIS7 than the 32-bit installer's version. Interestingly, it looks like it's still using the 32-bit IIS6 connector under IIS7, though.

I'm using a BufferedOutputStream which serves the ...

2009-01-23T16:11:00.000-06:00

I'm using a BufferedOutputStream which serves the same purpose as your StringBuffer suggestion would, but at a lower layer.

@Hem,

The Java example is not writing to disk after every loop because it's using the BufferedOutputStream; the ColdFusion example is writing on every iteration for the sake of code clarity. If I were buffering output, it'd be noticeably faster, but still not nearly as fast as the Java example.

TalkingTree,I was using the customer's LoadRunner ...

2009-01-23T16:03:00.000-06:00

TalkingTree,

I was using the customer's LoadRunner installation for those tests, and their scripts. The test results were consistent from test to (identical) test so I was confident of their usefullness. (Conversely, if the same test gives results that vary significantly from run to run, you really can't use that test for measuring the effects of changes.)

@Mike,

If you're running ColdFusion 64-bit, then you have a memory cap only barely theoretically reachable. (You need the 64-bit installer and ColdFusion 8.0.1 Enterprise to run 64-bit, though.)

Aside: It once seemed only theoretically reachable to use the whole of 2^32 bytes of RAM, because it was 65,536 times larger than the address space of a 16bit computer. Took only a few years to get 65,000x larger address spaces... but going from 2^32 to 2^64 is not "double that" by any means... we'd have to start needing four billion times more memory than present for 2^64 to become "crowded". The move from 64-bit address spaces to 128-bit address spaces will take a LOT longer than 16-bit to 32-bit did.

Great tidbit post here Daryl. Would it be faster ...

2009-01-23T16:03:00.000-06:00

Great tidbit post here Daryl. Would it be faster if you used a Java StringBuffer to build a few hundred rows before writing to disk? I think it would be faster to do that versus writing to disk on each column value. It would be an interesting follow up to this blog post to explore that.

Thanks for the heads-up, Daryl.Can you clarify som...

2009-01-23T12:57:00.000-06:00

Thanks for the heads-up, Daryl.

Can you clarify something for me? The "identically-configured datasources" - they all point to the same one dataBASE instance, correct? They do not point to some sort of a clustered database environment, right?

Also (and this may be a trivial question), I have a 64-bit machine on which I was just about to install a second CF instance (to be clustered). I believed this was needed to allocate more than 2Gb of memory to the instance, am I wrong? Is there no jrun/cf memory cap in 64-bit land?

Lastly, do you have any sort of data/results from your tests that we can all see?

Cheers!
Mike

Crazy question,Why are you writing to the disk aft...

2009-01-23T12:21:00.000-06:00

Crazy question,

Why are you writing to the disk after every loop?

Glad to you see some great posts from you Daryl. ...

2009-01-23T11:54:00.000-06:00

Glad to you see some great posts from you Daryl. Thanks.

What do you use nowadays for load testing?

Did you ever try to run your Cold Fusion applicati...

2009-01-20T18:52:00.000-06:00

Did you ever try to run your Cold Fusion applications in a 32-Bit IIS process? Search for Enable32BitAppOnWin64 for details.

nice blog...visit also coldfusion example

2009-01-19T05:47:00.000-06:00

nice blog...
visit also coldfusion example

kanika, sounds like form.dietchoice is defined as ...

2008-08-21T08:39:00.000-05:00

kanika,

sounds like form.dietchoice is defined as "" and therefore cf is evaluating reasona_ which doesnt exist

would still say use
variables["reason_#form.dietchoice#"]

and you might want to default it if it wasn't given a default value.

- Joel

I'm just not able to solve this issue..An error oc...

2008-08-21T08:35:00.000-05:00

I'm just not able to solve this issue..

An error occurred while evaluating the expression:

reasona_defined = #evaluate(""reasona_"" & form.dietchoice)#

An error has occurred while processing the expression:

reasona_

@yebillI know its way out of date. I found this bl...

2008-07-14T05:46:00.000-05:00

@yebill

I know its way out of date. I found this blog because I was trying to put people off Evaluate.

the answer is value="#variables["#tmpFieldValue#"]#"/>

It could get difficult within a cfc having used a var... maybe if you need to interpret it using a variable in an array/structure would be better.

Cheers,
Joel

I hope you don't mind if I use a modified version ...

2007-01-15T19:08:00.000-06:00

I hope you don't mind if I use a modified version of your function.

I changed the return string to:

dateString = DateFormat(ListGetAt(theDate.toGMTString(),1," ")&"-"&ListGetAt(theDate.toGMTString(),2," ")&"-"&ListGetAt(theDate.toGMTString(),3," "),"ddd")&", "&theDate.toGMTString();

which is in the date format that HTML uses. I did this because I am using your function to serve files and using ColdFusion to do specific authentication. I then set the HTTP Header variable "Last-modified" to this value and use cfcontent to server the files. I have a few other tricks up my sleeve in this template, as well. It's very cool.

Thanks for the help.

I've been reading that it's important to avoid eva...

2006-11-26T17:58:00.000-06:00

I've been reading that it's important to avoid evalute() in CF, but what about an include situation where the code calls for a variable to be evaluated and that variable may come from a form OR it might come from a query?

e.g.

< input name="#tmpFieldID#" type="text" class="inputText" id="#tmpFieldID#" value="#evaluate(tmpFieldValue)#" >

Very informative blog. I found everything I needed...

2006-05-02T21:58:00.000-05:00

Very informative blog. I found everything I needed here. I was able to complete my research. Jealous of the content!

I think you have a spammer(above).Anyways, I just ...

2006-01-06T10:24:00.000-06:00

I think you have a spammer(above).

Anyways, I just wanted to thank you for your post. It helped us resolve an issue we were having with our coldfusion site.

What a great idea!And it looks like it will coinci...

2005-04-01T22:19:00.000-06:00

What a great idea!

And it looks like it will coincide with PHP's new tag based release release, and Microsoft's reinbursement of all Window ME licenses sold since it's release.

:-)