Bill Karwin wrote:
Who is insisting that you use Table/Row Gateway for everything? Not me. I definitely agree that OO abstractions for data access are less speedy than writing SQL queries. I agree that they have their use, but no solution should be employed in all situations.
Regards,
Bill Karwin
I found this quite interesting. I dislike the encapsulation of SQL, I prefer to just write it.
I don't think the distinction is made in the ZF documents. It simply shows you how to use all the DB objects and implies you *should* be using them. This is where the confusion lies. I had a 'feeling' that I was somehow doing it wrong, but the more I hang out in this email list the more I realise that perhaps I'm doing it right.
Like you say, for simple queries, use what suits you best. For slow pages think about just using SQL and for very slow pages think about memcache or something.
monk.e.boy
