Recent Entries
- Real Season Begins!
- Good User Interface ...
- Restarting the User ...
- Flex Builder 3 Requi...
- A Good Night!
- OT: What happened to...
- Using jQuery
- Philly CFUG Dec. 18 ...
- Next Philly CFUG
- Philly CFUG Tomorrow
Popular Entries
- Import/Export in SQL...
- SAML and ColdFusion ...
- SAML and ColdFusion ...
- SAML and ColdFusion ...
- SQL Server 2005 Expr...
- SAML and ColdFusion ...
- Improving Performanc...
- Learning Flex
- SAML and ColdFusion ...
- Second Blog CFC Surv...
Top Commenters
- Nathan Mische (11)
- Peter Bell (4)
- Terrence Ryan (3)
- Scott (2)
- Jim Priest (2)
- David (2)
- Scott Stroz (2)
- Scott P (2)
- Justin Alpino (2)
- Ravneet (2)
Slideshows
Pool Surprises...Sponsored Links
Search
Subscribe
Enter your email address to subscribe to this blog.RSS
Tags
cfug coldfusion generalArchives
- Adobe (5) [RSS]
- AIR (6) [RSS]
- ASP.NET (2) [RSS]
- Books (1) [RSS]
- CFEclipse (5) [RSS]
- CFUG (24) [RSS]
- CFUnited (3) [RSS]
- ColdFusion (50) [RSS]
- College Football (3) [RSS]
- Conferences (1) [RSS]
- Development Tools (2) [RSS]
- DIY (1) [RSS]
- Eagles (3) [RSS]
- Fireworks (1) [RSS]
- Flash (3) [RSS]
- Flex (9) [RSS]
- Flyers (2) [RSS]
- Frameworks (5) [RSS]
- General (28) [RSS]
- Hockey (2) [RSS]
- Hosting (1) [RSS]
- House (2) [RSS]
- HTML (2) [RSS]
- JavaScript (1) [RSS]
- Jobs (1) [RSS]
- Macromedia (0) [RSS]
- Misc. (5) [RSS]
- Model-Glue (4) [RSS]
- Navy Football (5) [RSS]
- onair2007Philadelphia (3) [RSS]
- onairbustour (3) [RSS]
- Other Sports (4) [RSS]
- Performance (3) [RSS]
- Personal (2) [RSS]
- Phillies (2) [RSS]
- Projects, User Group Manager (1) [RSS]
- Rant (1) [RSS]
- Rants (1) [RSS]
- SAML (6) [RSS]
- Site (1) [RSS]
- Soccer (4) [RSS]
- SQL Server (2) [RSS]
- Transportation (1) [RSS]
- Wedding (2) [RSS]
AGGREGATORS
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.
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:
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.


philduba.com



