CF queries and memory

[Claude1]

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 ?

[BKBK · Accepted solution]

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.

[Claude1]

Thanks.

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