I need to access the same information across two tables but the date
changes as different intervals are selected (this is for a web page). So,
I thought creating a view would help speed things up, but upon doing an
'explain', I realized that's not the case. So, would it be best to create
a trigger that updates a separate table whenever information is changed on
the other two? That way I can do an easy select on table #3 without the
join.
Thanks!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Corporation http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~