Skip to main content
S
suchil00
Known Participant
May 14, 2009
Question

Array/Structure or QueryNew

  • May 14, 2009
  • 2 replies
  • 571 views

Recently I have had to work with data that I read off a Text File. I created the required pages using both Arrays and QueryNew funtions to manipulate the data. I did find QueryNew better suited for my purpose. Speed wise I could not see any noticeable difference. Server performance wise do any of you know if one is better than the other?

This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
May 14, 2009

try cfhttp.  The name attribute gives you a query.

ilssac
ilssac
Inspiring
May 14, 2009

A couple of years ago, I had a ColdFusion Engineer at a conference to us that ColdFusion is more efficient at hangling LARGE arrays then LARGE Record Sets.  As it is a web application server, not a database management system.

This was in reference to the preformance of Query of Query functionality that can often be sped up with a converstion to some type of Array logic.

And I would worry more about which version was easier to code, understand and maintain before I would ever worry about minor preformance differences until such a time is load and preformance testing tells me there is a problem.

But depending on what you where doing with those record sets after you built them with the QueryNew() functionality, it might, possible, maybe be slightly better if they where arrays.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices