MySQL CREATE EVENT Question
-
Hi, I want to ask how the CREATE EVENT in MySQL works? does it use the operating system event schedule (Wndows Task Scheduler, CRON, etc) or MySQL has its own event scheduler? and can you rely on MySQL CREATE EVENT or it's better to have a process in Windows task Scheduler?
Technology News @ www.JassimRahma.com
-
Hi, I want to ask how the CREATE EVENT in MySQL works? does it use the operating system event schedule (Wndows Task Scheduler, CRON, etc) or MySQL has its own event scheduler? and can you rely on MySQL CREATE EVENT or it's better to have a process in Windows task Scheduler?
Technology News @ www.JassimRahma.com
Jassim Rahma wrote:
and can you rely on MySQL
..well, if they say they implement a timer, you can rely on it that it works as described in the manual :)
Jassim Rahma wrote:
or it's better to have a process in Windows task Scheduler
That depends on your needs. If you are modifying data at a specified interval, then it might best be done in the database. If it doesn't need the database, then it would be better of in the task scheduler. Another big difference (does not make one better than the other) is how they are managed, and the person who has those permissions. For the task-scheduler that's the local Windows-admin, for MySQL it is probably the MySQL SA.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]