MySQL Forums
Forum List  »  Triggers

Trigger effenciy
Posted by: Tore Skobba
Date: March 21, 2006 04:39PM

Hi

I am considring using trigger in an application I am developing, basically I want to update an record in table A at every insert into an table B. However, in my application I have already fetched the record in table A (as I must fetch it), as such I am not sure what is most efficient. Either in my code update table B then table A, or make an trigger which automatically updates table A on insert into table B.

I am using PHP.

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger effenciy
2505
March 21, 2006 04:39PM
1829
March 22, 2006 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.