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.

Reply via email to