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

Does the ORM has some support for SQL_CACHE?

How can I support MySQL query cache options using the ORM?

SELECT SQL_CACHE something FROM table

Or disabling cache

SELECT SQL_NO_CACHE stuff FROM table

Thank's for any help :)



19.6k

I think you need to use PHQL, or raw sql, or ORM caching.

SQL_ NO_CACHE is a MySql implementation, not a SQL definition.



3.6k
in reply to Rafael Gonçalves

I think you need to use PHQL, or raw sql, or ORM caching.

SQL_ NO_CACHE is a MySql implementation, not a SQL definition.

I understand your point about is not a SQL definition, thank's :)

In the end, PHQL, ORM objects and such are converted to plain SQL queries. Query cache must be explicitly expressed to the MySQL server, to make this possible, needs to be apart in some kind of wrapper just for mysql support :/.

That's what I want to know, if there is any other way to tell to mysql for cache using my models....

Thanks anyway...