Skip to main content
Claude1
Inspiring
Jan 27, 2017 4:49 PM UTC
Answered

CF queries and memory

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 is closed to new replies. Start a new post to keep the conversation going.
BKBK
BKBKCorrect answer
Community Expert
Feb 8, 2017 9:50 AM UTC

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.

View reply

2 replies

BKBK
Community Expert
BKBKCommunity ExpertCorrect answer
Community Expert
Feb 8, 2017 9:50 AM UTC

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.

Translate
Claude1Author
Inspiring
Feb 8, 2017 3:11 PM UTC

Thanks.

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

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