closing result sets

paul13

Working with both asp and php, I have noticed that little or no attention is payed to closing result sets, while closing record sets as soon as possible is common practice in asp.

why this difference between the asp and php?

paul13

[deleted]

There is no difference. PHP also has functions to cleanup resultset memory.

But most of the programmers here are too 'lazy' to do it 🙂

paul13

Is the RS stored as a variable, like an array, or are RS's stored at the database? It seems to be stored somewhere else, which means a connection to get it is required.

I ask because, if the RS is stored at the database, and the information is just brought to the page when it is needed, it may make more sense to put the whole RS in an array imediately, and than close the connection with the RS.

Freeing the connection would sacrifice some memory, but would save on connections, and it seems like connections are more important than memory.

We seem to be getting into areas of PHP's design as opposed to coding. Is there a more appropriate place for me to have this discussion?

paul13

vincent wrote:

There is no difference. PHP also has functions to cleanup resultset memory.

But most of the programmers here are too 'lazy' to do it 🙂

[deleted]

"I ask because, if the RS is stored at the database, and the information is just brought to the page when it is needed, it may make more sense to put the whole RS in an array imediately, and than close the connection with the RS. "

Whatever for? Why would you want to use even more memory by copying all the data into an array?
Remember, the database can read the data from disk, it doesn't have to load everything into memory.

"Freeing the connection would sacrifice some memory, but would save on connections, and it seems like connections are more important than memory."

No. Memory is MUCH more important than connections.

paul13

memmory is more important than connections. that is nice to know.

wha about time. isn't it quicker to read an array, than to have to go and get the information about a RS every time?

I guess i can test this myself. I'll test it, and give you an answer.

paul