Ben Forta

AdobeStock_455007340

When Not to Use

The ColdFusion tag is used to group a set of SQL statements that need to be executed as a batch (allowing for rollbacks and explicit commits). But before you use this tag, stop and think – do you really need to do this? Could you process the entire set of statements within a stored procedure instead? If so, you’ll see significant performance gains, and the code will be far more manageable. Of course, not all block can be replaced with stored procedures, but many can (and should be). (Applies to: ColdFusion All)

Leave a Reply