Ok kinda figured this out, as Views act as independant tables then
simply creating another model class for them works:
Ie for Countries table I created countryselect view, to get all the
country rows i needed and ordered correctly.
$table = new models_fblovefootball_Countryselect();
$result = $table->fetchAll();
var_dump($result);
CAn anyone gives me any heads up on performance of using views, and
creating multiple views?
I believe it should be very fast as it caches the queries better, but
may mean extra disk space thats all, will do some more reading but any
pointers appreciated
Ian
Ian Warner wrote:
Hi
Does or will Zend_Db_Table have any methods to handle table related
Views, or should I just implement these through DB_Select?
Also wanted to know best practices on this has anyone coded in any
methods to simplify abstraction?
Cheers
Ian
