philduba.com

Improving Performance: Using Structures instead of Arrays

Posted On November 21, 2006 4:54 PM By Phil in ColdFusion,Performance

In this entry on performance, I want to talk about using Structures to help save performance. I believe Structures are probably one of the least utilized variable types in the CF Community, yet they are probably the most powerful. At work, in some of the reports I was looking at improving, they utilized a base query (which I talked about in earlier posts) but had supporting, aggregate-based queries. To add the SQL in these queries would critically drop the performance of the report.

[More]

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1060 Views

Improving Performance: Concatenating Large Strings

Posted On October 20, 2006 7:12 AM By Phil in ColdFusion,Performance

One of the more common programming tasks nowadays is to write audit log files, place large amounts of tracking within a database, or write large CSV files for export. The most common response when a question is asked on how to reduce the processing time of these transactions is to use the Java StringBuffer method. There is, however, a fairly straightforward method within ColdFusion itself that is just as efficient as using Java. This method is what I like to call the ArrayAppend/ArrayToList method. Let's look at a piece of code where a large CSV file is being created off of a very significatn report.
In the previous post in this series, I was referencing a User Group meeting/presentation/attendance list. I will continue to use the same example here. From the previous entry, the following query was being executed:

[More]

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 2131 Views

Improving Query Performance using Query of Queries

Posted On October 14, 2006 6:29 AM By Phil in ColdFusion,Performance

I think I'm going to start a little series on how to improve performance of a ColdFusion application using some of the techniques I've done at work to improve our products' overall performance. The first itemI'll explore is query performance. Now, there are many things one can do to improve performance such as removing Select *, adding the <CFQUERYPARAM> tag, using Joins, removing IN clauses, etc.

[More]

Comments (1) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1819 Views