select columns and call method in model

Question

select columns and call method in model

Created Jul '19	Last Reply Aug '19	Replies 1	Views 99	Votes 0

pejman hkh 342

Jul '19

Select columns in sql query has so effect in query speed. but in phalcon when we select columns can't use model functions and ...

how can solve this problem ?

Dylan Anderson · Answer 1 · 2019-07-25T12:28:10-07:00

Basically you can't. When you select only specific columns, that means the data you want is a subset of the complete record. Therefore you are, by definition, not wanting the whole record - which is what a model is a representation of.

If you want to use model methods - don't specify any columns. Like you said, it doesn't really have any effect on query speed.

pejman hkh · Answer 2 · 2019-07-26T01:23:16-07:00

Thank you Dylan,

Select all columns has effect in query speed. I think an option that solve this problem is good.