Skip to main content
C
Claude1
Inspiring
January 27, 2017
Answered

CF queries and memory

  • January 27, 2017
  • 1 reply
  • 800 views

Hi,

I am in the process of translating a CF application to PHP.

I have a question about queries, please tell me if I'm right:

If I understand well, the major difference  between CF queries and PHP queries is that in CF, the whole set of records is fetched and an array is generated containing all data in one shot. On the other hand in PHP, only one row is returned and one has to fetch rows one by one so it takes very less memory at a time.

Is this right ?

My application uses only rather small queries and the use of memory has never been a problem in the CF version, so I intend to emulate the way CF works in PHP to simplify the work of translation.

Any comment ?

This topic has been closed for replies.
Correct answer BKBK

There is no difference between ColdFusion and PHP in what you get when, for example, a select-query runs. In either case, you get a result-set containing all the rows and columns.

1 reply

BKBK
Community Expert
BKBKCommunity ExpertCorrect answer
Community Expert
February 8, 2017

There is no difference between ColdFusion and PHP in what you get when, for example, a select-query runs. In either case, you get a result-set containing all the rows and columns.

C
Claude1Author
Inspiring
February 8, 2017

Thanks.

I have made a class that emulate as close as possible the way CFQUERY works and it makes my conversion much easier.

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