Jurian Sluiman wrote:
>
>
> <snip>
>
> Hi,
> I'd go for neither of these methods. Create models for Users, Videos and
> Images and connect them together by using the relational features of
> Db_Table.
> Then call the getter for images only when required. You don't need to get
> the
> images at any time. Also, I suggest you cache the results so you don't
> need to
> pull the database every time. If a user changes his profile, delete the
> cache
> file and it's immediately updated in cache.
> R, Jurian
>
>
Hi Jurian,
Thanks for the response.
I like your proposal a lot. And actually I have thought about using Db_Table
and some caching mechanisme for these purposes too. But to tell you the
truth, I'm a bit apprehensive about how to exactly implement it. Especially
because from the documentation I wasn't too sure how to implement the
relationships for Db_Table for the MySql innoDB engine.
The docs state:
"Skip declaration of $_dependentTables if you use referential integrity
constraints in the RDBMS server to implement cascading operations";
But because of this statement, I'm a bit unsure of what I *do* need to
define in order to fully profit form Db_Table's relationship management and
profit from innoDB's cascading operations at the same time.
So basically my next question is:
How would I define relationships in Db_Table for innoDB tables without it
conflicting with each other. If you, or somebody else could elaborate on
this for me, I would much appreciate it.
Concerning cache: I absolutely need to dig in to this soon too, because I
really want to start taking advantage of caching. I haven't found the time
to dig into it yet though.
One question about cache that immediately pops up in my mind though is:
Zend_Cache docs speak of frontend and backend. What do these concepts refer
to? Is this as straightforward as I think it is: frontend is where you cache
stuff for your applications frontend and backend is where you cache stuff
for your application backend? Or am I missing something vital here?
Thanks in advance for any insights.
Cheers
--
View this message in context:
http://www.nabble.com/-OT--General-design-question-tp23623977p23638343.html
Sent from the Zend Framework mailing list archive at Nabble.com.