Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Update table slower in trigger than in procedure. Is this possible?
Started 1 month, 3 weeks ago by Emilio Nicolás
Hi all! I have a problem and I don't know how to solve it, I wish you could help me. Thanks in advance! I have developed a materialized view in MySql and it has about 1 million rows. When a table called 'users' is updated, the trigger AFTER UPDATE has to update as well the materialized view witch has relationship with the row UPDATE in 'users'. The trigger looks like follows: ...
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: Performance  Performance - forum profile
Total authors: 1 author
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Other posts in this thread:

Emilio Nicolás replied 1 month, 2 weeks ago
I guess i am crazy... but i already have the same problem! :-(
Size: 62 bytes
Customize:  Customize "<b>Reply 1</b>: Re: Update table slower in trigger than in procedure. Is this possible? :: Performance :: MySQL AB - MySQL Forums"

 

Top contributing authors

Name
Posts
Emilio Nicolás
2
user's latest post:
Re: Update table slower in...
Published (2009-11-02 07:12:00)
I guess i am crazy... but i already have the same problem! :-(

Related threads on "MySQL AB - MySQL Forums":

Updating same table via trigger/stored procedure  MySQL AB - MySQL Forums - site profile Triggers - forum profile Updating same table via trigger/stored procedure
Updating same table via trigger/stored procedure
How can i create table in stored procedure but pass the...  MySQL AB - MySQL Forums - site profile Newbie - forum profile How can i create table in stored procedure but pass the name of table as a parameter?
How can i create table in stored procedure but pass the name of table as a parameter?
Pass table name to procedure that creates the table  MySQL AB - MySQL Forums - site profile Install - forum profile Pass table name to procedure that creates the table
Pass table name to procedure that creates the table
Use SQL code from table inside Trigger  MySQL AB - MySQL Forums - site profile Newbie - forum profile Use SQL code from table inside Trigger
Use SQL code from table inside Trigger
How to Create a Table from trigger  MySQL AB - MySQL Forums - site profile Triggers - forum profile How to Create a Table from trigger
How to Create a Table from trigger
Update table with trigger  MySQL AB - MySQL Forums - site profile Triggers - forum profile Update table with trigger
Update table with trigger
Empty Table After Trigger  MySQL AB - MySQL Forums - site profile Triggers - forum profile Empty Table After Trigger
Empty Table After Trigger
Update a second table with trigger  MySQL AB - MySQL Forums - site profile Triggers - forum profile Update a second table with trigger
Update a second table with trigger
Find name of table in trigger  MySQL AB - MySQL Forums - site profile Triggers - forum profile Find name of table in trigger
Find name of table in trigger
Do not delete the tmp table in stored procedure???  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile Do not delete the tmp table in stored procedure???
Do not delete the tmp table in stored procedure???

Related threads on other sites:

Trigger doesn't log into the audit table if the column of...  MSDN Forums - site profile Transact-SQL - forum profile Trigger doesn't log into the audit table if the column of table has trigger on is null - MSDN Forums
Trigger doesn't log into the audit table if the column of table has trigger on is null - MSDN Forums
Update table into trigger but on same table trigger based  dBforums - Database Support Community - site profile DB2 - forum profile Update table into trigger but on same table trigger based
Update table into trigger but on same table trigger based
Create/Insert/Compare temp table with main table in...  C# Forum : C#, VB.NET, WCF, WPF, Silverlight, WF, XAML, .NET 3.0, .NET 3.5, Visual Studio 2008 Forums - site profile ADO.NET & Database - forum profile Create/Insert/Compare temp table with main table in stored procedure?
Create/Insert/Compare temp table with main table in stored procedure?
What is the difference between: a table create using...  TechNet Forums - site profile Getting started with SQL Server - forum profile What is the difference between: a table create using Table variable and using # temporary table in Stored Procedure - TechNet Forums
What is the difference between: a table create using Table variable and using # temporary table in Stored Procedure - TechNet Forums
Trigger procedure each time you navigate through records  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Using Forms - forum profile Trigger procedure each time you navigate through records
Trigger procedure each time you navigate through records
Creation table dans une procedure stockee - table temporaire  Forums de Developpez.com - site profile Firebird - forum profile Creation table dans une procedure stockee - table temporaire
Creation table dans une procedure stockee - table temporaire
PL/SQL Trying to update a table through trigger on the...  Expert Communities - bytes - site profile oracle - forum profile PL/SQL Trying to update a table through trigger on the same table
PL/SQL Trying to update a table through trigger on the same table
Mysql5: view, trigger, procedure - SGBD/SQL -...  FORUM HardWare.fr - site profile SGBD/SQL - forum profile Mysql5: view, trigger, procedure - SGBD/SQL - Programmation - FORUM HardWare.fr
Mysql5: view, trigger, procedure - SGBD/SQL - Programmation - FORUM HardWare.fr
How to create Delete trigger procedure  C# Forum : C#, VB.NET, WCF, WPF, Silverlight, WF, XAML, .NET 3.0, .NET 3.5, Visual Studio 2008 Forums - site profile SQL Server - forum profile How to create Delete trigger procedure
How to create Delete trigger procedure
Replacing Mk II Trigger - Procedure  http://www.rugerforum.com - site profile http://www.rugerforum.com - forum profile Replacing Mk II Trigger - Procedure
Replacing Mk II Trigger - Procedure
Thread profile page for "Update table slower in trigger than in procedure. Is this possible?" on http://www.mysql.com. This report page is a snippet summary view from a single thread "Update table slower in trigger than in procedure. Is this possible?", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity