Greaser9780 Posted March 3, 2007 Share Posted March 3, 2007 Is it possible to have mysql do something everytime it updates a certain table? I have a function I would like to run evertime a table is updated. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/ Share on other sites More sharing options...
fenway Posted March 3, 2007 Share Posted March 3, 2007 PHP function? Not really... with triggers, you can get MySQL to do some fancy stuff, though. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-198625 Share on other sites More sharing options...
Greaser9780 Posted March 3, 2007 Author Share Posted March 3, 2007 Would it be possible to have it run a check to see if it needs to update every time a certain row is updated? Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-198832 Share on other sites More sharing options...
fenway Posted March 4, 2007 Share Posted March 4, 2007 Have what check? Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-198854 Share on other sites More sharing options...
Greaser9780 Posted March 13, 2007 Author Share Posted March 13, 2007 I have a timer and another program I currently run as CRON jobs. I would like to utilize a trigger instead though. One script is a check to see if a timer has run out. The other checks to see if a user made a predetermined choice before it is his/her turn to enter their choice. The latter checks if a pre-choice has been made and when it is the users turn updates the db with their info. Since the program I made will be duplicated many times I was wondering if all the CRON jobs would put a large load on the server. In order for the program to seem efficient each CRON would have to run almost every minute or 2. I figure if I can get a trigger to do it then it would only run when the db is updated. A signifigant server load reduction and better timing for the site. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-206074 Share on other sites More sharing options...
fenway Posted March 13, 2007 Share Posted March 13, 2007 I'm confused about what you're trying to do... Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-206282 Share on other sites More sharing options...
Greaser9780 Posted March 14, 2007 Author Share Posted March 14, 2007 I'd like to set up a way to run a php file everytime the db is updated. I would prolly have to use a require after every single UPDATE query to the db though. Would rather do a trigger but wasn't sure if you could have a trigger run a php file. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-206770 Share on other sites More sharing options...
fenway Posted March 14, 2007 Share Posted March 14, 2007 You can't have a DB trigger do anything outside the DB... a cron job is better suited for this. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-207167 Share on other sites More sharing options...
Greaser9780 Posted March 14, 2007 Author Share Posted March 14, 2007 What is a good rule of thumb for timing of CRON jobs?I currently run 4 on a site 2 everyten minutes and 2 every minute. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-207357 Share on other sites More sharing options...
fenway Posted March 14, 2007 Share Posted March 14, 2007 Depends how much work they're doing... I have cron jobs running every minute, but 99% of the time, they do nothing. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-207388 Share on other sites More sharing options...
Greaser9780 Posted March 14, 2007 Author Share Posted March 14, 2007 They basically check to see if a program is started.If it is it runs through a series of variables and usually ends up running 1-3 simple queries. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-207459 Share on other sites More sharing options...
fenway Posted March 14, 2007 Share Posted March 14, 2007 Then you shouldn't have any issues. Link to comment https://forums.phpfreaks.com/topic/40979-solved-is-this-possible/#findComment-207467 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.