[Solar-talk] Solar_Sql_Model Feedback

[Ian Szewczyk]

I've been messing around with the model system included in Solar and
it works pretty well, especially letting the relations setup joins
automatically. One issue however that I couldn't get around too easily
is when dealing large collections (it isn't even that big, 50 records)
that include eager loaded records. The data is already there, but when
getting around to iterating it generates many record objects, and this
slows things down pretty significantly, especially if you have more
relations. Is there a way to just iterate through the data, and
optionally load the row objects if they are needed? Generating that
many objects when in most cases you just want to spit out the data
(which can be loaded ahead of time by specifying the eager stuff)
seems like overkill to me... I mean, I could just add a "data()"
method that returns _data, but then that would mean I'd have to access
the related records by double underscore which seems pretty
counter-intuitive.

Also, maybe you could consider loading the select objects through
dependencies possibly? In case I'm using a custom Solar_Sql_Select?

-- 
IAN SZEWCZYK
roamzero at gmail.com
iaszew01 at louisville.edu