We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Cache property in ResultSet

Can somebody explain for what purposes there is cache property in the Resultset class?

We have used custom Decorator with Backend (Cache) to do benchmarks and faced some problems. When we use cache in models, it stores serialized resultset class with Cache property. We had Decorator in that property with whole benchmarks, so it was enough large.

I added __sleep method to the Decorator, so now cached Resultsets haven't Backend inside cache property. And Resulsets still works as expected.

I had issues with GetColumnHeader() in CacheActiveX. It ignored the section definition in the ROWSPEC optionalDescription for the column. And I couldn't understand the reason. But then found Using ActiveX with Caché: The ResultSet Class Intersystems doc Book expert.